DBA Data[Home] [Help]

APPS.PAY_CA_DIRECT_DEPOSIT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 32: , pay_assignment_actions paa

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')
36: and ppp.org_payment_method_id +0 =

Line 63: , pay_assignment_actions paa

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 =
67: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

Line 112: , pay_assignment_actions paa

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')
116: and ppp.org_payment_method_id +0 =

Line 143: , pay_assignment_actions paa

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 =
147: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

Line 192: , pay_assignment_actions paa

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')
196: and ppp.org_payment_method_id +0 =

Line 224: , pay_assignment_actions paa

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 =
228: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

Line 276: , pay_assignment_actions paa

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')
280: and ppp.org_payment_method_id +0 =

Line 307: , pay_assignment_actions paa

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 =
311: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')