APPS.CSF_RESOURCE_PUB dependencies on CSF_GPS_DEVICE_ASSIGNMENTS

Line 2634: FROM csf_gps_device_assignments a

2630: WHERE lookup_type = 'CSF_GPS_DEVICE_STATUSES'
2631: AND lookup_code = 'AT_HOME';
2632: CURSOR c_device_res_map_exists IS
2633: SELECT count(*)
2634: FROM csf_gps_device_assignments a
2635: WHERE a.resource_id = p_resource_id
2636: AND a.resource_type = p_resource_type
2637: AND NVL(p_date, SYSDATE) BETWEEN a.start_date_active AND NVL(a.end_date_active, SYSDATE + 1);
2638: BEGIN