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 2773: pay_payroll_Actions ppa

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

Line 2788: ,pay_payroll_actions ppa

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

Line 3253: ,pay_payroll_actions ppa

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

Line 4001: FROM pay_payroll_Actions ppa

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