APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_A_LOCATIONS

Line 2409: FROM csi_a_locations cal

2405: l_time_stamp date;
2406:
2407: CURSOR fa_location_cur IS
2408: SELECT cal.fa_location_id fa_location_id
2409: FROM csi_a_locations cal
2410: WHERE cal.location_id = l_location_id
2411: AND cal.location_table = 'HR_LOCATIONS'
2412: AND l_location_type_code = 'INVENTORY'
2413: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate

Line 2417: FROM csi_a_locations cal

2413: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate
2414: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate
2415: UNION
2416: SELECT cal.fa_location_id fa_location_id
2417: FROM csi_a_locations cal
2418: WHERE location_id = l_location_id
2419: AND l_location_type_code IN ('HZ_LOCATIONS', 'IN_TRANSIT', 'PROJECT') -- Modified for bug 8651868
2420: AND cal.location_table IN ('HZ_LOCATIONS','LOCATION_CODES','HR_LOCATIONS')
2421: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate

Line 2425: FROM csi_a_locations cal

2421: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate
2422: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate
2423: UNION
2424: SELECT cal.fa_location_id fa_location_id
2425: FROM csi_a_locations cal
2426: WHERE location_id = l_location_id
2427: AND l_location_type_code IN ('HR_LOCATIONS','INTERNAL_SITE')
2428: AND cal.location_table IN ('HR_LOCATIONS')
2429: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate

Line 2433: FROM csi_a_locations cal,

2429: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate
2430: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate
2431: UNION
2432: SELECT cal.fa_location_id fa_location_id
2433: FROM csi_a_locations cal,
2434: hz_party_sites hzps
2435: WHERE hzps.location_id = cal.location_id
2436: AND hzps.party_site_id = l_location_id -- Modified for bug 4149685
2437: AND l_location_type_code = 'HZ_PARTY_SITES'