DBA Data[Home] [Help]

APPS.PQP_UTILITIES dependencies on PAY_ELEMENT_SET_MEMBERS

Line 3484: FROM pay_element_set_members pes

3480: )
3481: IS
3482: SELECT distinct pee.element_entry_id
3483: ,pde.datetracked_event_id
3484: FROM pay_element_set_members pes
3485: ,pay_element_entries_f pee
3486: ,pay_datetracked_events pde
3487: WHERE pes.element_set_id = p_element_set_id
3488: AND pee.element_type_id = pes.element_type_id

Line 3524: FROM pay_element_set_members pes

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
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