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 2774: FROM pay_run_results prr,

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