DBA Data[Home] [Help]

APPS.CTO_AUTO_PROCURE_PK dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1158: from hr_all_organization_units org,

1154: -- There is a user setup needed for IR. Refer to PO manuals.
1155:
1156: /* Commented as part of bugfix 7162037
1157: select org.location_id into x_location_id
1158: from hr_all_organization_units org,
1159: hr_locations_all loc
1160: where org.organization_id = p_org_id
1161: and org.location_id = loc.location_id
1162: and exists(select 1 from po_location_associations_all pla

Line 1182: from hr_all_organization_units org,

1178: elsif p_source_type = 3 then
1179:
1180: -- For ER's validating against hr_locations is enough
1181: select org.location_id into x_location_id
1182: from hr_all_organization_units org,
1183: hr_locations_all loc
1184: where org.organization_id = p_org_id
1185: and org.location_id = loc.location_id;
1186: