DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4929: hr_all_organization_units org,

4925: AND NOT EXISTS
4926: (
4927: SELECT 1
4928: FROM org_organization_definitions ood,
4929: hr_all_organization_units org,
4930: hr_organization_information ori
4931: WHERE ood.organization_id = org.organization_id
4932: AND org.organization_id = ori.organization_id
4933: AND ori.org_information_context = 'CLASS'

Line 4950: hr_all_organization_units org,

4946: AND NOT EXISTS
4947: (
4948: SELECT 1
4949: FROM org_organization_definitions ood,
4950: hr_all_organization_units org,
4951: hr_organization_information ori
4952: WHERE ood.organization_id = org.organization_id
4953: AND org.organization_id = ORI.organization_id
4954: AND ori.org_information_context = 'CLASS'

Line 4979: HR_ALL_ORGANIZATION_UNITS ORG,

4975: SET Inventory_Org_id =
4976: (
4977: SELECT OOD.ORGANIZATION_ID
4978: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
4979: HR_ALL_ORGANIZATION_UNITS ORG,
4980: HR_ORGANIZATION_INFORMATION ORI
4981: WHERE OOD.ORGANIZATION_ID = ORG.organization_id
4982: AND ORG.organization_id = ORI.organization_id
4983: AND ORI.org_information_context = 'CLASS'