APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on AP_POL_LOCATIONS_VL

Line 472: from ap_pol_locations_vl

468: ------------------------------------------------------------------------
469:
470: CURSOR loc_cur IS
471: select location_id
472: from ap_pol_locations_vl
473: where upper(location) = upper(decode(p_location_type, 'CITY', location, p_location))
474: and location_type = p_location_type
475: and nvl(city_locality_id, -1) = nvl(p_city_locality_id, -1)
476: and nvl(county_id, -1) = nvl(p_county_id, -1)

Line 523: from ap_pol_locations_vl

519: l_city_locality_id NUMBER;
520:
521: CURSOR undefined_conus_cur IS
522: select location_id
523: from ap_pol_locations_vl
524: where city_locality_id = l_city_locality_id
525: and territory_code = 'US'
526: and rownum = 1;
527:

Line 575: from ap_pol_locations_vl

571: ------------------------------------------------------------------------
572:
573: CURSOR undefined_cur IS
574: select location_id
575: from ap_pol_locations_vl
576: where undefined_location_flag = 'Y'
577: and territory_code is null
578: and rownum = 1;
579:

Line 618: from ap_pol_locations_vl

614: ------------------------------------------------------------------------
615:
616: CURSOR loc_status_cur IS
617: select status
618: from ap_pol_locations_vl
619: where location_id = p_location_id;
620:
621: loc_status_rec loc_status_cur%ROWTYPE;
622: