APPS.IGS_AD_IMP_008 dependencies on FND_TERRITORIES_VL

Line 772: l_territory_short_name FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

768: l_site_use_last_update_date DATE;
769: l_profile_last_update_date DATE;
770: l_row_id VARCHAR2(30);
771: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
772: l_territory_short_name FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
773: l_Check VARCHAR2(30);
774: l_object_version_number NUMBER;
775:
776: PROCEDURE Update_Addr(addr_rec addr_c%ROWTYPE , reladdr_rec reladdr_rec_c%ROWTYPE , p_rel_person_id NUMBER) AS

Line 1046: CURSOR terr_name_cur(p_territory_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE) IS

1042: END Update_Addr;
1043: -- End Local Procedure Update_Addr
1044: -- Start Local Procedure to validate address
1045: PROCEDURE Validate_reladdr(reladdr_rec IN reladdr_rec_c%ROWTYPE , p_rel_person_id IN NUMBER , l_Check OUT NOCOPY VARCHAR2 ) AS
1046: CURSOR terr_name_cur(p_territory_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE) IS
1047: SELECT territory_short_name
1048: FROM fnd_territories_vl
1049: WHERE territory_code = p_territory_code;
1050:

Line 1048: FROM fnd_territories_vl

1044: -- Start Local Procedure to validate address
1045: PROCEDURE Validate_reladdr(reladdr_rec IN reladdr_rec_c%ROWTYPE , p_rel_person_id IN NUMBER , l_Check OUT NOCOPY VARCHAR2 ) AS
1046: CURSOR terr_name_cur(p_territory_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE) IS
1047: SELECT territory_short_name
1048: FROM fnd_territories_vl
1049: WHERE territory_code = p_territory_code;
1050:
1051: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1052: SELECT birth_date

Line 5264: FROM fnd_territories_vl

5260:
5261: -- validate the territory if passed
5262: CURSOR c_country(cp_territory_code VARCHAR2) IS
5263: SELECT 'X' var
5264: FROM fnd_territories_vl
5265: WHERE territory_code = NVL(cp_territory_code,'0');
5266:
5267: country_rec c_country%ROWTYPE;
5268: