DBA Data[Home] [Help]

APPS.WSH_CAL_ASG_VALIDATIONS dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1279: FROM HZ_CUST_ACCT_SITES_ALL HCAS,

1275: WCA.LOCATION_ID = p_location_id)
1276: UNION ALL
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,

Line 1336: FROM HZ_CUST_ACCT_SITES_ALL HCAS,

1332: --Bug 8855773:Added the cursor, that would get the default shipping/receiving/carrier Calendar
1333: -- defined for a particular customer or an Organization.
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,