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
1286: and HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
1334: CURSOR c_get_calendar_code_wo_loc IS
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