pay_element_entry_api

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