DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 1536: from pay_element_entries_f EE, pay_element_links_f EL

1532: p_element_type_id in number,
1533: p_commit_calculation_end_dt in date) is
1534: Select EE.element_entry_id, EE.creator_type,
1535: ee.effective_start_date, ee.effective_end_date
1536: from pay_element_entries_f EE, pay_element_links_f EL
1537: Where EL.element_type_id = p_element_type_id
1538: --AND p_commit_calculation_dt between EL.effective_start_date and EL.effective_end_date
1539: and EL.effective_start_date < p_commit_calculation_end_dt
1540: and EL.effective_end_date > p_commit_calculation_dt