DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on PAY_PROCESS_EVENTS

Line 1945: -- column 'NOTED_VALUE' of pay_process_events fro purged

1941: -- puged element entries.
1942: -- the element tntry ids are fetched by comparing the
1943: -- element type id in the element set attached to the
1944: -- event group and the element type id stored in the
1945: -- column 'NOTED_VALUE' of pay_process_events fro purged
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

Line 1951: ,pay_process_events ppe

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
1955: AND ppe.noted_value = petr.element_type_id