60: ,ppa.payroll_action_id
61:
62: FROM pay_payroll_actions ppa,
63: pay_assignment_actions paa,
64: per_all_assignments_f paf,
65: pay_pre_payments ppp,
66: pay_org_payment_methods_f pop,
67: pay_payment_types ppt,
68: pay_org_pay_method_usages_f ppu
108: ,'PAYROLL_ACTION_ID=C' , ppa.payroll_action_id
109: ,'ASSIGNMENT_ACTION_ID=C', paa.assignment_action_id
110:
111: FROM pay_assignment_actions paa,
112: per_all_assignments_f paf,
113: pay_payroll_actions ppa,
114: pay_pre_payments ppp,
115: PAY_ORG_PAYMENT_METHODS_F pop,
116: per_all_people_f pef,
166: , substr(pap.first_name,1,35)
167: ,'LAST_NAME=P'
168: ,substr(pap.last_name,1,35)
169: FROM pay_assignment_actions act,
170: per_all_assignments_f asg,
171: pay_payroll_actions pa2,
172: pay_payroll_actions pa1,
173: pay_pre_payments ppp,
174: pay_org_payment_methods_f OPM,
247: , substr(pap.first_name,1,35)
248: ,'LAST_NAME=P'
249: ,substr(pap.last_name,1,35)
250: FROM pay_assignment_actions act,
251: per_all_assignments_f asg,
252: pay_payroll_actions pa2,
253: pay_payroll_actions pa1,
254: pay_pre_payments ppp,
255: pay_org_payment_methods_f OPM,
324: ,'ORG_ACCOUNT_NO=P'
325: ,pea.segment6
326:
327: FROM pay_assignment_actions paa,
328: per_all_assignments_f paf,
329: pay_payroll_actions ppa,
330: pay_pre_payments ppp,
331: pay_org_payment_methods_f pop,
332: per_all_people_f pef,