APPS.WSH_CAL_ASG_VALIDATIONS dependencies on HR_ORGANIZATION_UNITS

Line 1237: hr_organization_units HR

1233: WCA.ENABLED_FLAG
1234: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1235: PO_VENDORS POV ,
1236: PO_VENDOR_SITES_all POVS ,
1237: hr_organization_units HR
1238: WHERE WCA.ASSOCIATION_TYPE = 'VENDOR_SITE'
1239: AND WCA.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID
1240: AND POV.VENDOR_ID = POVS.VENDOR_ID
1241: AND hr.organization_id = povs.org_id

Line 1363: HR_ORGANIZATION_UNITS HOU

1359: SELECT WCA.CALENDAR_CODE,
1360: WCA.ENABLED_FLAG
1361: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1362: WSH_LOCATIONS WLO,
1363: HR_ORGANIZATION_UNITS HOU
1364: WHERE HOU.LOCATION_ID = WLO.source_LOCATION_ID
1365: And wlo.location_source_code='HR'
1366: AND WLO.wsh_location_id = p_location_id
1367: AND WCA.organization_id = HOU.organization_id