APPS.CSF_GPS_PUB dependencies on FND_LOOKUPS

Line 119: FROM fnd_lookups

115: c_location_cursor SYS_REFCURSOR;
116:
117: CURSOR c_status_lookup IS
118: SELECT NVL(meaning, 'UNKNOWN')
119: FROM fnd_lookups
120: WHERE lookup_type = 'CSF_GPS_DEVICE_STATUSES'
121: AND lookup_code = 'UNKNOWN';
122: BEGIN
123: IF p_device_id IS NOT NULL THEN

Line 135: SELECT NVL(fl.meaning, stmap.internal_status_code) FROM fnd_lookups fl, csf_gps_vendor_status_maps stmap

131: , l.parked_time
132: , l.address
133: , d.device_tag
134: , (
135: SELECT NVL(fl.meaning, stmap.internal_status_code) FROM fnd_lookups fl, csf_gps_vendor_status_maps stmap
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

Line 160: SELECT NVL(fl.meaning, stmap.internal_status_code) FROM fnd_lookups fl, csf_gps_vendor_status_maps stmap

156: , l.parked_time
157: , l.address
158: , d.device_tag
159: , (
160: SELECT NVL(fl.meaning, stmap.internal_status_code) FROM fnd_lookups fl, csf_gps_vendor_status_maps stmap
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

Line 222: l_status_code_meaning fnd_lookups.meaning%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
226: , p_resource_id => p_resource_id