APPS.CSF_TASKS_PUB dependencies on CSF_MAP_ACCESS_HOURS_VL

Line 1784: SELECT * from csf_map_access_hours_vl where

1780: l_auto_acc_hrs VARCHAR2(1);
1781: l_task_status_flag VARCHAR2(1);
1782:
1783: CURSOR c_acchrs_location_csr IS
1784: SELECT * from csf_map_access_hours_vl where
1785: customer_location_id = l_acchr_loc_id;
1786:
1787: CURSOR c_acchrs_ctsite_csr IS
1788: SELECT * from csf_map_access_hours_vl where

Line 1788: SELECT * from csf_map_access_hours_vl where

1784: SELECT * from csf_map_access_hours_vl where
1785: customer_location_id = l_acchr_loc_id;
1786:
1787: CURSOR c_acchrs_ctsite_csr IS
1788: SELECT * from csf_map_access_hours_vl where
1789: customer_id = l_acchr_ct_id and
1790: customer_site_id = l_acchr_ct_site_id;
1791:
1792:

Line 1794: SELECT * from csf_map_access_hours_vl where

1790: customer_site_id = l_acchr_ct_site_id;
1791:
1792:
1793: CURSOR c_acchrs_ct_csr IS
1794: SELECT * from csf_map_access_hours_vl where
1795: customer_id = l_acchr_ct_id
1796: and customer_site_id is NULL
1797: and customer_location_id is NULL;
1798: l_acchrs_setups_rec c_acchrs_location_csr%ROWTYPE;

Line 5702: SELECT * from csf_map_access_hours_vl where

5698: x_object_version_number NUMBER;
5699: l_auto_acc_hrs VARCHAR2(1);
5700:
5701: CURSOR c_acchrs_location_csr IS
5702: SELECT * from csf_map_access_hours_vl where
5703: customer_location_id = l_acchr_loc_id;
5704:
5705: CURSOR c_acchrs_ctsite_csr IS
5706: SELECT * from csf_map_access_hours_vl where

Line 5706: SELECT * from csf_map_access_hours_vl where

5702: SELECT * from csf_map_access_hours_vl where
5703: customer_location_id = l_acchr_loc_id;
5704:
5705: CURSOR c_acchrs_ctsite_csr IS
5706: SELECT * from csf_map_access_hours_vl where
5707: customer_id = l_acchr_ct_id and
5708: customer_site_id = l_acchr_ct_site_id;
5709:
5710: CURSOR c_acchrs_ct_csr IS

Line 5711: SELECT * from csf_map_access_hours_vl where

5707: customer_id = l_acchr_ct_id and
5708: customer_site_id = l_acchr_ct_site_id;
5709:
5710: CURSOR c_acchrs_ct_csr IS
5711: SELECT * from csf_map_access_hours_vl where
5712: customer_id = l_acchr_ct_id
5713: and customer_site_id is NULL
5714: and customer_location_id is NULL;
5715: l_acchrs_setups_rec c_acchrs_location_csr%ROWTYPE;