APPS.OZF_UTILITY_PVT dependencies on JTF_LOC_HIERARCHIES_VL

Line 1412: FROM jtf_loc_hierarchies_vl

1408: l_obj_area2 VARCHAR2(30);
1409:
1410: CURSOR c_area2 IS
1411: SELECT area2_code
1412: FROM jtf_loc_hierarchies_vl
1413: WHERE location_hierarchy_id = p_country_id;
1414:
1415: CURSOR c_camp_area2 IS
1416: SELECT B.area2_code

Line 1417: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B

1413: WHERE location_hierarchy_id = p_country_id;
1414:
1415: CURSOR c_camp_area2 IS
1416: SELECT B.area2_code
1417: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B
1418: WHERE A.campaign_id = p_object_id
1419: AND A.city_id = B.location_hierarchy_id;
1420:
1421: BEGIN