DBA Data[Home] [Help]

APPS.JTF_LOC_PVT dependencies on JTF_LOC_POSTAL_CODES

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 274: FROM jtf_loc_postal_codes

270: WHERE location_area_id = l_parent_id;
271:
272: CURSOR c_postal_codes IS
273: SELECT location_postal_code_id
274: FROM jtf_loc_postal_codes
275: WHERE location_area_id = l_area_id;
276:
277: BEGIN
278: