DBA Data[Home] [Help]

APPS.JTF_LOC_PVT dependencies on JTF_LOC_AREAS_VL

Line 261: FROM jtf_loc_areas_vl area, jtf_loc_postal_codes postal

257: area.program_update_date,
258: area.start_date_active,
259: area.end_date_active,
260: postal.location_postal_code_id
261: FROM jtf_loc_areas_vl area, jtf_loc_postal_codes postal
262: WHERE area.location_area_id = postal.location_area_id (+);
263:
264: CURSOR c_parent_area IS
265: SELECT location_area_id,

Line 269: FROM jtf_loc_areas_vl

265: SELECT location_area_id,
266: location_area_code,
267: location_type_code,
268: parent_location_area_id
269: FROM jtf_loc_areas_vl
270: WHERE location_area_id = l_parent_id;
271:
272: CURSOR c_postal_codes IS
273: SELECT location_postal_code_id