DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on PAY_ELEMENT_TYPE_RULES

Line 1916: FROM pay_element_type_rules petr

1912: ,p_end_date IN DATE
1913: )
1914: IS
1915: SELECT distinct pee.element_entry_id
1916: FROM pay_element_type_rules petr
1917: ,pay_element_entries_f pee
1918: WHERE petr.element_set_id = p_element_set_id
1919: AND pee.element_type_id = petr.element_type_id
1920: AND pee.assignment_id = p_assignment_id

Line 1950: FROM pay_element_type_rules petr

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