APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on CSF_MAP_ACCESS_HOURS_VL

Line 243: SELECT * from csf_map_access_hours_vl where

239: l_address_id_to_pass NUMBER;
240: l_location_id_to_pass NUMBER;
241:
242: CURSOR c_acchrs_location_csr IS
243: SELECT * from csf_map_access_hours_vl where
244: customer_location_id = l_acchr_loc_id;
245:
246: CURSOR c_acchrs_ctsite_csr IS
247: SELECT * from csf_map_access_hours_vl where

Line 247: SELECT * from csf_map_access_hours_vl where

243: SELECT * from csf_map_access_hours_vl where
244: customer_location_id = l_acchr_loc_id;
245:
246: CURSOR c_acchrs_ctsite_csr IS
247: SELECT * from csf_map_access_hours_vl where
248: customer_id = l_acchr_ct_id and
249: customer_site_id = l_acchr_ct_site_id;
250:
251: CURSOR c_acchrs_ct_csr IS

Line 252: SELECT * from csf_map_access_hours_vl where

248: customer_id = l_acchr_ct_id and
249: customer_site_id = l_acchr_ct_site_id;
250:
251: CURSOR c_acchrs_ct_csr IS
252: SELECT * from csf_map_access_hours_vl where
253: customer_id = l_acchr_ct_id;
254:
255: l_acchrs_setups_rec c_acchrs_location_csr%ROWTYPE;
256: