DBA Data[Home] [Help]

APPS.PAY_IE_PAYPATH_TAPE dependencies on HR_ORGANIZATION_INFORMATION

Line 48: , hr_organization_information org

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

Line 120: , hr_organization_information org

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

Line 197: , hr_organization_information org

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