DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on PAY_ELEMENT_TYPE_RULES

Line 1920: FROM pay_element_type_rules petr

1916: ,p_end_date IN DATE
1917: )
1918: IS
1919: SELECT distinct pee.element_entry_id
1920: FROM pay_element_type_rules petr
1921: ,pay_element_entries_f pee
1922: WHERE petr.element_set_id = p_element_set_id
1923: AND pee.element_type_id = petr.element_type_id
1924: AND pee.assignment_id = p_assignment_id

Line 1954: FROM pay_element_type_rules petr

1950: -- element entry events.
1951: CURSOR csr_get_purged_ee_ids (p_element_set_id IN NUMBER)
1952: IS
1953: SELECT distinct ppe.surrogate_key
1954: FROM pay_element_type_rules petr
1955: ,pay_process_events ppe
1956: ,pay_event_updates peu
1957: WHERE petr.element_set_id = p_element_set_id
1958: AND ppe.assignment_id = p_assignment_id