APPS.CSF_GPS_PUB dependencies on CSF_GPS_DEVICES

Line 54: l_label csf_gps_devices.device_tag%TYPE;

50: , p_date DATE DEFAULT NULL
51: )
52: RETURN VARCHAR2 IS
53: --
54: l_label csf_gps_devices.device_tag%TYPE;
55: --
56: CURSOR c_device_label IS
57: SELECT device_tag
58: FROM csf_gps_devices

Line 58: FROM csf_gps_devices

54: l_label csf_gps_devices.device_tag%TYPE;
55: --
56: CURSOR c_device_label IS
57: SELECT device_tag
58: FROM csf_gps_devices
59: WHERE device_id = p_device_id;
60: --
61: CURSOR c_resource_device_label IS
62: SELECT device_tag

Line 64: , csf_gps_devices d

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);
68: BEGIN

Line 140: , csf_gps_devices d

136: WHERE fl.lookup_type = 'CSF_GPS_DEVICE_STATUSES' AND fl.lookup_code = stmap.internal_status_code AND stmap.vendor_status_code = l.status
137: ) status_code_meaning
138: , l.creation_date
139: FROM csf_gps_location_feeds l
140: , csf_gps_devices d
141: WHERE d.device_id = p_device_id
142: AND l.device_id = d.device_id
143: -- AND (
144: -- p_date IS NULL AND l.creation_date > SYSDATE - 1

Line 166: , csf_gps_devices d

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
170: AND d.device_id = a.device_id

Line 221: l_device_tag csf_gps_devices.device_tag%TYPE;

217: l_direction csf_gps_location_feeds.direction%TYPE;
218: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
219: l_address csf_gps_location_feeds.address%TYPE;
220: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
221: l_device_tag csf_gps_devices.device_tag%TYPE;
222: l_status_code_meaning fnd_lookups.meaning%TYPE;
223: BEGIN
224: get_location(
225: p_device_id => p_device_id

Line 406: FROM csf_gps_devices

402: FROM csf_gps_vendors_vl;
403: --
404: CURSOR c_vendor_devices(v_vendor_id NUMBER) IS
405: SELECT device_id, device_tag
406: FROM csf_gps_devices
407: WHERE vendor_id = v_vendor_id;
408: --
409: CURSOR c_territory_resources IS
410: SELECT resource_id, resource_type