APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 3128: l_token := 'WSH_CALENDAR_ASSIGNMENTS';

3124: END IF;
3125: END ;
3126:
3127: BEGIN
3128: l_token := 'WSH_CALENDAR_ASSIGNMENTS';
3129: IF l_debug_on THEN
3130: wsh_debug_sv.LOG(l_module_name, 'Validating records in table', l_token);
3131: END IF;
3132: v_delete_permitted := NULL;

Line 3135: FROM WSH_CALENDAR_ASSIGNMENTS WCA, WSH_LOCATIONS WSH

3131: END IF;
3132: v_delete_permitted := NULL;
3133: SELECT 'N'
3134: INTO v_delete_permitted
3135: FROM WSH_CALENDAR_ASSIGNMENTS WCA, WSH_LOCATIONS WSH
3136: WHERE WCA.LOCATION_ID = P_LOCATION_ID
3137: AND WSH.WSH_LOCATION_ID = WCA.LOCATION_ID
3138: AND WSH.LOCATION_SOURCE_CODE = 'HR'
3139: AND ROWNUM = 1;