DBA Data[Home] [Help]

APPS.PAY_IN_TERMINATION_PKG dependencies on PAY_RUN_RESULTS

Line 1307: FROM pay_run_results prr,

1303: IS
1304: --
1305: CURSOR csr_element_proc IS
1306: SELECT 1
1307: FROM pay_run_results prr,
1308: pay_assignment_actions paa,
1309: pay_element_types_f pet,
1310: pay_payroll_Actions ppa
1311: WHERE paa.assignment_id = p_assignment_id

Line 2771: FROM pay_run_results prr,

2767: AND pet2.business_group_id = p_business_group_id
2768: AND pet2.element_name = SUBSTR(pet.element_name,1,INSTR(pet.element_name,' Recover',-1))||'Advance'
2769: AND p_actual_termination_date BETWEEN pet.effective_start_date AND pet.effective_end_date
2770: AND EXISTS (SELECT '1'
2771: FROM pay_run_results prr,
2772: pay_assignment_actions paa,
2773: pay_payroll_Actions ppa
2774: WHERE paa.assignment_id = g_assignment_id
2775: AND paa.assignment_action_id = prr.assignment_action_id