APPS.WSH_CAL_ASG_VALIDATIONS dependencies on HZ_PARTY_SITES

Line 1255: hz_party_sites hps,

1251: SELECT WCA.CALENDAR_CODE,
1252: WCA.ENABLED_FLAG
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

Line 1281: HZ_PARTY_SITES HPS,

1277: SELECT WCA.CALENDAR_CODE,
1278: WCA.ENABLED_FLAG
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

Line 1320: HZ_PARTY_SITES HPS

1316: UNION ALL
1317: SELECT WCA.CALENDAR_CODE,
1318: WCA.ENABLED_FLAG
1319: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1320: HZ_PARTY_SITES HPS
1321: WHERE WCA.ASSOCIATION_TYPE = 'CARRIER_SITE'
1322: AND WCA.CARRIER_ID = HPS.PARTY_ID
1323: AND WCA.CARRIER_SITE_ID = HPS.PARTY_SITE_ID
1324: ----

Line 1339: HZ_PARTY_SITES HPS,

1335: SELECT WCA.CALENDAR_CODE,WCA.ENABLED_FLAG
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