APPS.WSH_CAL_ASG_VALIDATIONS dependencies on WSH_LOCATIONS

Line 1257: wsh_locations wl

1253: FROM WSH_CALENDAR_ASSIGNMENTS WCA,
1254: hz_relationships rel,
1255: hz_party_sites hps,
1256: hz_party_site_uses hpsu,
1257: wsh_locations wl
1258: WHERE WCA.ASSOCIATION_TYPE = 'VENDOR_LOCATION'
1259: AND WCA.LOCATION_ID = WL.WSH_LOCATION_ID
1260: AND hps.party_id = rel.subject_id
1261: AND hps.party_site_id = hpsu.party_site_id

Line 1283: WSH_LOCATIONS WLO,

1279: FROM HZ_CUST_ACCT_SITES_ALL HCAS,
1280: HZ_CUST_SITE_USES_ALL HCSU,
1281: HZ_PARTY_SITES HPS,
1282: HZ_CUST_ACCOUNTS HCA,
1283: WSH_LOCATIONS WLO,
1284: WSH_CALENDAR_ASSIGNMENTS WCA
1285: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
1286: and HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
1287: AND HCAS.cust_account_id = hca.cust_account_id

Line 1305: WSH_LOCATIONS WLO

1301:
1302: SELECT WCA.CALENDAR_CODE,
1303: WCA.ENABLED_FLAG
1304: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1305: WSH_LOCATIONS WLO
1306: WHERE WCA.ASSOCIATION_TYPE = 'HR_LOCATION'
1307: AND WCA.LOCATION_ID = WLO.WSH_LOCATION_ID(+)
1308: ----
1309: AND 'ORGANIZATION' = l_entity_type

Line 1340: WSH_LOCATIONS WLO,

1336: FROM HZ_CUST_ACCT_SITES_ALL HCAS,
1337: HZ_CUST_SITE_USES_ALL HCSU,
1338: HZ_CUST_ACCOUNTS HCA,
1339: HZ_PARTY_SITES HPS,
1340: WSH_LOCATIONS WLO,
1341: wsh_calendar_assignments WCA
1342: WHERE HCAS.party_site_id = HPS.party_site_id
1343: AND HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
1344: AND HCAS.cust_account_id = hca.cust_account_id

Line 1362: WSH_LOCATIONS WLO,

1358:
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