DBA Data[Home] [Help]

APPS.PQP_UTILITIES dependencies on PAY_PROCESS_EVENTS

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

3515: -- puged element entries.
3516: -- the element tntry ids are fetched by comparing the
3517: -- element type id in the element set attached to the
3518: -- event group and the element type id stored in the
3519: -- column 'NOTED_VALUE' of pay_process_events fro purged
3520: -- element entry events.
3521: CURSOR csr_get_purged_ee_ids (p_element_set_id IN NUMBER)
3522: IS
3523: SELECT distinct ppe.surrogate_key

Line 3525: ,pay_process_events ppe

3521: CURSOR csr_get_purged_ee_ids (p_element_set_id IN NUMBER)
3522: IS
3523: SELECT distinct ppe.surrogate_key
3524: FROM pay_element_set_members pes
3525: ,pay_process_events ppe
3526: ,pay_event_updates peu
3527: WHERE pes.element_set_id = p_element_set_id
3528: AND ppe.assignment_id = p_assignment_id
3529: AND ppe.noted_value = pes.element_type_id