APPS.PAY_CA_DIRECT_DEPOSIT_PKG dependencies on PER_ASSIGNMENTS

Line 31: , per_assignments paf

27: 'TRANSFER_COUNT=P', count(paf.person_id)
28: , 'TRANSFER_PERSON_ID=P', paf.person_id
29: from
30: pay_pre_payments ppp
31: , per_assignments paf
32: , pay_assignment_actions paa
33: where
34: paa.payroll_action_id =
35: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 62: , per_assignments paf

58: , pay_personal_payment_methods ppm
59: , pay_external_accounts pea
60: , pay_pre_payments ppp
61: , per_people ppf
62: , per_assignments paf
63: , pay_assignment_actions paa
64: where paa.payroll_action_id =
65: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
66: and ppp.org_payment_method_id +0 =

Line 111: , per_assignments paf

107: 'TRANSFER_COUNT=P', count(paf.person_id)
108: , 'TRANSFER_PERSON_ID=P', paf.person_id
109: from
110: pay_pre_payments ppp
111: , per_assignments paf
112: , pay_assignment_actions paa
113: where
114: paa.payroll_action_id =
115: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 142: , per_assignments paf

138: , pay_personal_payment_methods ppm
139: , pay_external_accounts pea
140: , pay_pre_payments ppp
141: , per_people ppf
142: , per_assignments paf
143: , pay_assignment_actions paa
144: where paa.payroll_action_id =
145: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
146: and ppp.org_payment_method_id +0 =

Line 191: , per_assignments paf

187: 'TRANSFER_COUNT=P', count(paf.person_id)
188: , 'TRANSFER_PERSON_ID=P', paf.person_id
189: from
190: pay_pre_payments ppp
191: , per_assignments paf
192: , pay_assignment_actions paa
193: where
194: paa.payroll_action_id =
195: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 223: , per_assignments paf

219: , pay_personal_payment_methods ppm
220: , pay_external_accounts pea
221: , pay_pre_payments ppp
222: , per_people ppf
223: , per_assignments paf
224: , pay_assignment_actions paa
225: where paa.payroll_action_id =
226: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
227: and ppp.org_payment_method_id +0 =

Line 275: , per_assignments paf

271: 'TRANSFER_COUNT=P', count(paf.person_id)
272: , 'TRANSFER_PERSON_ID=P', paf.person_id
273: from
274: pay_pre_payments ppp
275: , per_assignments paf
276: , pay_assignment_actions paa
277: where
278: paa.payroll_action_id =
279: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 306: , per_assignments paf

302: , pay_personal_payment_methods ppm
303: , pay_external_accounts pea
304: , pay_pre_payments ppp
305: , per_people ppf
306: , per_assignments paf
307: , pay_assignment_actions paa
308: where paa.payroll_action_id =
309: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
310: and ppp.org_payment_method_id +0 =