DBA Data[Home] [Help]

APPS.PAY_IE_PAYPATH_TAPE dependencies on HR_ORGANIZATION_INFORMATION

Line 52: , hr_organization_information org

48: , per_all_people_f p
49: , pay_external_accounts oea
50: , pay_external_accounts pea
51: , hr_organization_units hou
52: , hr_organization_information org
53:
54: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464
55: where
56: ppa.payroll_action_id = -- Bug No 3513042

Line 124: , hr_organization_information org

120: , per_all_assignments_f a -- Bug No 3513042
121: , per_all_people_f p
122: , pay_external_accounts oea
123: , pay_external_accounts pea
124: , hr_organization_information org
125: where ppa.payroll_action_id = -- Bug No 3513042
126: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
127: and ppp.pre_payment_id = paa.pre_payment_id
128: and paa.payroll_action_id = ppa.payroll_action_id

Line 201: , hr_organization_information org

197: , per_all_assignments_f a -- Bug No 3513042
198: , per_all_people_f p
199: , pay_external_accounts oea
200: , pay_external_accounts pea
201: , hr_organization_information org
202: where ppa.payroll_action_id = -- Bug No 3513042
203: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
204: and ppp.pre_payment_id = paa.pre_payment_id
205: and paa.payroll_action_id = ppa.payroll_action_id

Line 274: , hr_organization_information org

270: , per_all_people_f p
271: , pay_external_accounts oea
272: , pay_external_accounts pea
273: , hr_organization_units hou
274: , hr_organization_information org
275:
276: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464
277: where
278: ppa.payroll_action_id = -- Bug No 3513042

Line 344: , hr_organization_information org

340: , per_all_assignments_f a -- Bug No 3513042
341: , per_all_people_f p
342: , pay_external_accounts oea
343: , pay_external_accounts pea
344: , hr_organization_information org
345: where ppa.payroll_action_id = -- Bug No 3513042
346: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
347: and ppp.pre_payment_id = paa.pre_payment_id
348: and paa.payroll_action_id = ppa.payroll_action_id

Line 424: , hr_organization_information org

420: , per_all_assignments_f a -- Bug No 3513042
421: , per_all_people_f p
422: , pay_external_accounts oea
423: , pay_external_accounts pea
424: , hr_organization_information org
425: where ppa.payroll_action_id = -- Bug No 3513042
426: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
427: and ppp.pre_payment_id = paa.pre_payment_id
428: and paa.payroll_action_id = ppa.payroll_action_id