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_UTILS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 28: FROM pay_assignment_actions paa

24: IS
25: CURSOR c_max_act_seq
26: IS
27: SELECT MAX(paa.action_sequence)
28: FROM pay_assignment_actions paa
29: ,pay_payroll_actions ppa
30: WHERE paa.payroll_action_id = ppa.payroll_action_id
31: AND ppa.action_type = p_process_type
32: AND paa.assignment_id = p_assignment_id

Line 377: pay_assignment_actions paa

373:
374: SELECT prt.run_type_name into l_run_type_name
375: FROM pay_run_types_f prt,
376: pay_payroll_actions ppa,
377: pay_assignment_actions paa
378: WHERE ppa.payroll_action_id = p_payroll_action_id
379: AND paa.payroll_action_id = ppa.payroll_action_id
380: AND prt.run_type_id = paa.run_type_id
381: AND paa.assignment_action_id = p_assignment_action_id

Line 1357: ,pay_assignment_actions paa

1353: IS
1354: CURSOR c_act_type IS
1355: SELECT 'L'
1356: FROM pay_payroll_actions ppa
1357: ,pay_assignment_actions paa
1358: WHERE paa.payroll_action_id = ppa.payroll_action_id
1359: AND paa.assignment_action_id = p_assignment_action_id
1360: AND EXISTS (SELECT 1
1361: FROM pay_payroll_Actions ppa2