DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 5733: FROM hr_organization_information OI,

5729: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699
5730: AND aid.org_id = ai.org_id
5731: AND AID.org_id IN
5732: ( SELECT ASP.org_id
5733: FROM hr_organization_information OI,
5734: --hr_all_organization_units_tl LE, --bug6392886
5735: hr_all_organization_units_tl OU,
5736: ap_system_parameters_all ASP
5737: WHERE ASP.org_id = OI.organization_id

Line 5764: FROM hr_organization_information OI,

5760: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699
5761: AND aid.org_id = ai.org_id
5762: AND AID.org_id IN
5763: ( SELECT ASP.org_id
5764: FROM hr_organization_information OI,
5765: --hr_all_organization_units_tl LE, --bug6392886
5766: hr_all_organization_units_tl OU,
5767: ap_system_parameters_all ASP
5768: WHERE ASP.org_id = OI.organization_id

Line 5803: FROM hr_organization_information OI,

5799: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699
5800: and ac.org_id = aph.org_id
5801: AND APH.org_id IN
5802: ( SELECT ASP.org_id
5803: FROM hr_organization_information OI,
5804: --hr_all_organization_units_tl LE, --bug6392886
5805: hr_all_organization_units_tl OU,
5806: ap_system_parameters_all ASP
5807: WHERE ASP.org_id = OI.organization_id

Line 5841: FROM hr_organization_information OI,

5837: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699
5838: and ac.org_id = aph.org_id
5839: AND APH.org_id IN
5840: ( SELECT ASP.org_id
5841: FROM hr_organization_information OI,
5842: --hr_all_organization_units_tl LE, bug6392886
5843: hr_all_organization_units_tl OU,
5844: ap_system_parameters_all ASP
5845: WHERE ASP.org_id = OI.organization_id