APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_A_LOCATIONS

Line 2145: FROM csi_a_locations cal

2141: l_time_stamp date;
2142:
2143: CURSOR fa_location_cur IS
2144: SELECT cal.fa_location_id fa_location_id
2145: FROM csi_a_locations cal
2146: WHERE cal.location_id = l_location_id
2147: AND cal.location_table = 'HR_LOCATIONS'
2148: AND l_location_type_code = 'INVENTORY'
2149: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate

Line 2153: FROM csi_a_locations cal

2149: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate
2150: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate
2151: UNION
2152: SELECT cal.fa_location_id fa_location_id
2153: FROM csi_a_locations cal
2154: WHERE location_id = l_location_id
2155: AND l_location_type_code IN ('HZ_LOCATIONS', 'IN_TRANSIT')
2156: AND cal.location_table IN ('HZ_LOCATIONS','LOCATION_CODES',
2157: 'HR_LOCATIONS')

Line 2162: FROM csi_a_locations cal

2158: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate
2159: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate
2160: UNION
2161: SELECT cal.fa_location_id fa_location_id
2162: FROM csi_a_locations cal
2163: WHERE location_id = l_location_id
2164: AND l_location_type_code IN ('HR_LOCATIONS','INTERNAL_SITE')
2165: AND cal.location_table IN ('HR_LOCATIONS')
2166: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate

Line 2170: FROM csi_a_locations cal,

2166: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate
2167: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate
2168: UNION
2169: SELECT cal.fa_location_id fa_location_id
2170: FROM csi_a_locations cal,
2171: hz_party_sites hzps
2172: WHERE hzps.location_id = cal.location_id
2173: AND hzps.party_site_id = l_location_id -- Modified for bug 4149685
2174: AND l_location_type_code = 'HZ_PARTY_SITES'