DBA Data[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on PAY_RUN_RESULTS

Line 334: , pay_run_results prr

330: Cursor c_del_ele is
331: SELECT petTL.element_name
332: FROM pay_element_types_f_tl petTL
333: , pay_element_types_f pet
334: , pay_run_results prr
335: WHERE prr.source_id = p_element_entry_id
336: AND prr.source_type = 'E'
337: AND prr.element_type_id = pet.element_type_id
338: AND pet.element_type_id = petTL.element_type_id

Line 397: , pay_run_results prr

393: prr.source_id entry,
394: pde.datetracked_event_id
395: FROM pay_assignment_actions paa
396: , pay_payroll_actions ppa
397: , pay_run_results prr
398: , pay_datetracked_events pde
399: WHERE prr.source_type = 'E'
400: AND prr.assignment_action_id = paa.assignment_action_id
401: AND paa.assignment_id = p_asg

Line 466: , pay_run_results prr

462: pde.datetracked_event_id,
463: p_event_group_id
464: FROM pay_assignment_actions paa
465: , pay_payroll_actions ppa
466: , pay_run_results prr
467: , pay_datetracked_events pde
468: WHERE prr.source_type = 'E'
469: AND prr.assignment_action_id = paa.assignment_action_id
470: AND prr.element_type_id = prr.element_type_id

Line 540: , pay_run_results prr

536: pde.datetracked_event_id,
537: nvl(pet.recalc_event_group_id, -1) event_group_id
538: FROM pay_assignment_actions paa
539: , pay_payroll_actions ppa
540: , pay_run_results prr
541: , pay_element_types_f pet
542: , pay_datetracked_events pde
543: WHERE prr.source_type = 'E'
544: AND prr.assignment_action_id = paa.assignment_action_id