APPS.CSF_GPS_PUB dependencies on CSF_GPS_DEVICE_ASSIGNMENTS

Line 63: FROM csf_gps_device_assignments a

59: WHERE device_id = p_device_id;
60: --
61: CURSOR c_resource_device_label IS
62: SELECT device_tag
63: FROM csf_gps_device_assignments a
64: , csf_gps_devices d
65: WHERE a.resource_id = p_resource_id
66: AND a.resource_type = p_resource_type
67: AND NVL(p_date, SYSDATE) BETWEEN a.start_date_active AND NVL(a.end_date_active, SYSDATE + 1);

Line 165: , csf_gps_device_assignments a

161: WHERE fl.lookup_type = 'CSF_GPS_DEVICE_STATUSES' AND fl.lookup_code = stmap.internal_status_code AND stmap.vendor_status_code = l.status
162: ) status_code_meaning
163: , l.creation_date
164: FROM csf_gps_location_feeds l
165: , csf_gps_device_assignments a
166: , csf_gps_devices d
167: WHERE a.resource_id = p_resource_id
168: AND a.resource_type = p_resource_type
169: AND a.device_id = l.device_id

Line 369: FROM csf_gps_device_assignments

365:
366: DELETE csf_gps_location_feeds
367: WHERE device_id IN (
368: SELECT device_id
369: FROM csf_gps_device_assignments
370: WHERE resource_id = p_resource_id
371: AND resource_type = p_resource_type
372: AND start_date_active < p_end_date
373: AND NVL(end_date_active, SYSDATE) > p_start_date

Line 476: FROM csf_gps_device_assignments

472:
473: DELETE csf_gps_location_feeds
474: WHERE device_id IN (
475: SELECT device_id
476: FROM csf_gps_device_assignments
477: WHERE device_assignment_id = p_device_assignment_id
478: AND start_date_active < l_end_date
479: AND NVL(end_date_active, SYSDATE) > l_start_date
480: )