APPS.CSF_RESOURCE_PUB dependencies on FND_LOOKUPS

Line 2629: FROM fnd_lookups

2625: l_mapping_count PLS_INTEGER := 0;
2626: --
2627: CURSOR c_status_lookup IS
2628: SELECT NVL(meaning, 'AT_HOME')
2629: FROM fnd_lookups
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(*)

Line 2786: l_status_code_meaning fnd_lookups.meaning%TYPE;

2782: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2783: l_address csf_gps_location_feeds.address%TYPE;
2784: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2785: l_device_tag csf_gps_devices.device_tag%TYPE;
2786: l_status_code_meaning fnd_lookups.meaning%TYPE;
2787: BEGIN
2788: get_location(
2789: x_msg_count => l_msg_count
2790: , x_msg_data => l_msg_data

Line 2829: l_status_code_meaning fnd_lookups.meaning%TYPE;

2825: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2826: l_address csf_gps_location_feeds.address%TYPE;
2827: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2828: l_device_tag csf_gps_devices.device_tag%TYPE;
2829: l_status_code_meaning fnd_lookups.meaning%TYPE;
2830: BEGIN
2831: get_location(
2832: x_msg_count => l_msg_count
2833: , x_msg_data => l_msg_data