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

Line 62: pay_assignment_actions paa,

58: ,'PAYROLL_ACTION_ID=C'
59: ,ppa.payroll_action_id
60:
61: FROM pay_payroll_actions ppa,
62: pay_assignment_actions paa,
63: per_all_assignments_f paf,
64: pay_pre_payments ppp
65:
66: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 99: FROM pay_assignment_actions paa,

95: ,'PAYROLL_ID=C' , paf.payroll_id
96: ,'PAYROLL_ACTION_ID=C' , ppa.payroll_action_id
97: ,'ASSIGNMENT_ACTION_ID=C', paa.assignment_action_id
98:
99: FROM pay_assignment_actions paa,
100: per_all_assignments_f paf,
101: pay_payroll_actions ppa,
102: pay_pre_payments ppp,
103: pay_org_payment_methods_f pop,

Line 151: FROM pay_assignment_actions act,

147: ,'FIRST_NAME=P'
148: , substr(pap.first_name,1,35)
149: ,'LAST_NAME=P'
150: ,substr(pap.last_name,1,35)
151: FROM pay_assignment_actions act,
152: per_all_assignments_f asg,
153: pay_payroll_actions pa2,
154: pay_payroll_actions pa1,
155: pay_pre_payments ppp,

Line 190: pay_assignment_actions act2,

186: AND hr_asg.assignment_id = asg.assignment_id
187: ))
188: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
189: FROM pay_action_interlocks pai1,
190: pay_assignment_actions act2,
191: pay_payroll_actions appa
192: WHERE pai1.locked_action_id = act.assignment_action_id
193: AND act2.assignment_action_id = pai1.locking_action_id
194: AND act2.payroll_action_id = appa.payroll_action_id

Line 230: FROM pay_assignment_actions act,

226: ,'FIRST_NAME=P'
227: , substr(pap.first_name,1,35)
228: ,'LAST_NAME=P'
229: ,substr(pap.last_name,1,35)
230: FROM pay_assignment_actions act,
231: per_all_assignments_f asg,
232: pay_payroll_actions pa2,
233: pay_payroll_actions pa1,
234: pay_pre_payments ppp,

Line 270: pay_assignment_actions act2,

266: AND hr_asg.assignment_id = asg.assignment_id
267: ))
268: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
269: FROM pay_action_interlocks pai1,
270: pay_assignment_actions act2,
271: pay_payroll_actions appa
272: WHERE pai1.locked_action_id = act.assignment_action_id
273: AND act2.assignment_action_id = pai1.locking_action_id
274: AND act2.payroll_action_id = appa.payroll_action_id

Line 305: FROM pay_assignment_actions paa,

301: ,sum(ppp.value)
302: ,'ORG_ACCOUNT_NO=P'
303: ,pea.segment6
304:
305: FROM pay_assignment_actions paa,
306: per_all_assignments_f paf,
307: pay_payroll_actions ppa,
308: pay_pre_payments ppp,
309: pay_org_payment_methods_f pop,