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_AU_PAYMENT_SUMMARY dependencies on PAY_ACTION_INTERLOCKS

Line 742: from pay_action_interlocks pail,

738: and rppa.effective_date between paaf.effective_start_date and paaf.effective_end_date /*Bug 3815301 */
739: )
740: and not exists
741: (select distinct paat.assignment_id
742: from pay_action_interlocks pail,
743: pay_assignment_actions paat,
744: pay_payroll_actions paas
745: where paat.assignment_id = a.assignment_id
746: and paas.action_type ='X'

Line 823: from pay_action_interlocks pail,

819: and rppa.effective_date between paaf.effective_start_date and paaf.effective_end_date /*Bug 3815301 */
820: )
821: and not exists
822: (select distinct paat.assignment_id
823: from pay_action_interlocks pail,
824: pay_assignment_actions paat,
825: pay_payroll_actions paas
826: where paat.assignment_id = a.assignment_id
827: and paas.action_type ='X'

Line 921: FROM pay_action_interlocks pail,

917: AND rppa.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date /*Bug 3815301 */
918: )
919: AND NOT EXISTS
920: (SELECT paat.assignment_id
921: FROM pay_action_interlocks pail,
922: pay_assignment_actions paat,
923: pay_payroll_actions paas
924: WHERE paat.assignment_id = a.assignment_id
925: AND paas.action_type ='X'

Line 2300: from pay_action_interlocks pai

2296: c_payroll_action_id pay_payroll_actions.payroll_action_id%type,
2297: c_year_start date,
2298: c_year_end date )
2299: is select to_char(pppa.effective_date,'DDMMYYYY')
2300: from pay_action_interlocks pai
2301: ,pay_assignment_actions pac
2302: ,pay_payroll_actions ppa
2303: ,pay_assignment_actions ppac
2304: ,pay_payroll_actions pppa