eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_TERMINATION_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 446: pay_payroll_actions ppa,

442: ptp.start_date,
443: ptp.end_date
444: FROM
445: per_time_periods ptp,
446: pay_payroll_actions ppa,
447: pay_assignment_actions paa
448: WHERE ptp.payroll_id = p_payroll_id
449: AND ptp.start_date between TRUNC(p_start_date,'MM') AND p_end_date
450: AND ptp.payroll_id = ppa.payroll_id

Line 466: pay_payroll_actions ppa,

462: ptp.start_date,
463: ptp.end_date
464: FROM
465: per_time_periods ptp,
466: pay_payroll_actions ppa,
467: pay_assignment_actions paa
468: WHERE ptp.payroll_id = p_payroll_id
469: AND ptp.payroll_id = ppa.payroll_id
470: AND ptp.time_period_id = ppa.time_period_id

Line 1310: pay_payroll_Actions ppa

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
1312: AND paa.assignment_action_id = prr.assignment_action_id
1313: AND paa.payroll_action_id= ppa.payroll_action_id
1314: AND ppa.action_type in('R','Q','B')

Line 2776: pay_payroll_Actions ppa

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
2779: AND paa.payroll_action_id= ppa.payroll_action_id
2780: AND ppa.action_type in('R','Q','B')

Line 2791: ,pay_payroll_actions ppa

2787:
2788: CURSOR csr_asact_id IS
2789: SELECT MAX(paa.assignment_action_id)
2790: FROM pay_assignment_actions paa
2791: ,pay_payroll_actions ppa
2792: WHERE paa.assignment_id = g_assignment_id
2793: AND paa.payroll_action_id = ppa.payroll_action_id
2794: AND paa.action_status = 'C'
2795: AND paa.source_action_id IS NULL

Line 3256: ,pay_payroll_actions ppa

3252:
3253: CURSOR csr_asact_id IS
3254: SELECT max(paa.assignment_action_id)
3255: FROM pay_assignment_actions paa
3256: ,pay_payroll_actions ppa
3257: WHERE paa.assignment_id = g_assignment_id
3258: AND paa.payroll_action_id = ppa.payroll_action_id
3259: AND paa.action_status = 'C'
3260: AND paa.source_action_id IS NULL

Line 4004: FROM pay_payroll_Actions ppa

4000: IS
4001:
4002: CURSOR c_max_asact IS
4003: SELECT MAX(paa.assignment_action_id)
4004: FROM pay_payroll_Actions ppa
4005: ,pay_assignment_actions paa
4006: WHERE paa.assignment_id =p_assignment_id
4007: AND paa.payroll_action_id = ppa.payroll_Action_id
4008: AND ppa.action_type in('R','Q')