332:
333:
334: CURSOR get_country(cp_country VARCHAR2) IS
335: SELECT territory_short_name
336: FROM fnd_territories_vl
337: WHERE territory_code = cp_country;
338:
339: CURSOR get_lkup_meaning(cp_lk_code VARCHAR2) IS
340: SELECT meaning
596: ORDER BY location_profile_id DESC;
597:
598: CURSOR get_country(cp_country VARCHAR2) IS
599: SELECT territory_short_name
600: FROM fnd_territories_vl
601: WHERE territory_code = cp_country;
602:
603: rec_chk_oss_party chk_oss_party%ROWTYPE;
604: rec_location_dtls get_location_dtls%ROWTYPE;