APPS.IGS_AD_IMP_007 dependencies on FND_TERRITORIES_VL

Line 2664: FROM fnd_territories_vl

2660:
2661: -- gmuralid validation for country changed - SEVIS
2662: CURSOR c_valid_country(cp_territory_code VARCHAR2) IS
2663: SELECT territory_short_name
2664: FROM fnd_territories_vl
2665: WHERE territory_code = cp_territory_code;
2666:
2667: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2668: SELECT birth_date FROM

Line 2913: FROM fnd_territories_vl

2909: l_last_update_date DATE;
2910:
2911: CURSOR c_valid_country(cp_territory_code VARCHAR2) IS
2912: SELECT territory_short_name
2913: FROM fnd_territories_vl
2914: WHERE territory_code = cp_territory_code;
2915:
2916: CURSOR c_null_hndlg (pcz_rec IN c_pcz%ROWTYPE) IS
2917: SELECT *