APPS.PNT_LOCATION_FEATURES_PKG dependencies on PN_LOCATIONS_ALL

Line 52: SELECT org_id FROM pn_locations_all WHERE location_id = x_LOCATION_ID AND ROWNUM = 1;

48: FROM PN_LOCATION_FEATURES_ALL
49: WHERE LOCATION_FEATURE_ID = x_location_feature_id;
50:
51: CURSOR org_cur IS
52: SELECT org_id FROM pn_locations_all WHERE location_id = x_LOCATION_ID AND ROWNUM = 1;
53:
54: l_org_ID NUMBER;
55:
56: BEGIN