Question: How to find parameters that are needed for pay_element_entry_api.
Ans:
SELECT element_link_id,
petf.element_type_id
FROM pay_element_links_f LINK,
pay_element_types_f petf
WHERE
TRUNC (SYSDATE) BETWEEN LINK.effective_start_date AND LINK.effective_end_date
AND UPPER (petf.element_name) IN (Element Name’)
AND TRUNC (SYSDATE) BETWEEN petf.effective_start_date AND petf.effective_end_date AND LINK.element_type_id = petf.element_type_id;
-- Soham Khot
-----
Send your questions to soham_khot@yahoo.com
Dec 9, 2007
pay_element_entry_api
Subscribe to:
Post Comments (Atom)
2 comments:
Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!
Once you've got the element_type_id using the element name, the is an API to find the right element_link_id:
hr_entry_api.get_link
Please see the package spec for more info.
Post a Comment