DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PER_ALL_ASSIGNMENTS_F

Line 63: per_all_assignments_f paf,

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')
67: and ppp.pre_payment_id = paa.pre_payment_id

Line 100: per_all_assignments_f paf,

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,
104: per_all_people_f pef,

Line 152: per_all_assignments_f asg,

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,
156: pay_org_payment_methods_f OPM,

Line 231: per_all_assignments_f asg,

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,
235: pay_org_payment_methods_f OPM,

Line 306: per_all_assignments_f paf,

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,
310: per_all_people_f pef,