DBA Data[Home] [Help]

APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on CSF_MAP_ACCESS_HOURS_VL

Line 266: SELECT * from csf_map_access_hours_vl where

262: l_address_id_to_pass NUMBER;
263: l_location_id_to_pass NUMBER;
264:
265: CURSOR c_acchrs_location_csr IS
266: SELECT * from csf_map_access_hours_vl where
267: customer_location_id = l_acchr_loc_id;
268:
269: CURSOR c_acchrs_ctsite_csr IS
270: SELECT * from csf_map_access_hours_vl where

Line 270: SELECT * from csf_map_access_hours_vl where

266: SELECT * from csf_map_access_hours_vl where
267: customer_location_id = l_acchr_loc_id;
268:
269: CURSOR c_acchrs_ctsite_csr IS
270: SELECT * from csf_map_access_hours_vl where
271: customer_id = l_acchr_ct_id and
272: customer_site_id = l_acchr_ct_site_id;
273:
274: CURSOR c_acchrs_ct_csr IS

Line 275: SELECT * from csf_map_access_hours_vl where

271: customer_id = l_acchr_ct_id and
272: customer_site_id = l_acchr_ct_site_id;
273:
274: CURSOR c_acchrs_ct_csr IS
275: SELECT * from csf_map_access_hours_vl where
276: customer_id = l_acchr_ct_id;
277:
278:
279: l_acchrs_setups_rec c_acchrs_location_csr%ROWTYPE;