APPS.IGS_AD_IMP_002 dependencies on FND_TERRITORIES_VL

Line 3582: CURSOR terr_name_cur(cp_territory_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE) IS

3578: SELECT birth_date
3579: FROM igs_pe_person_base_v
3580: WHERE person_id = cp_person_id;
3581:
3582: CURSOR terr_name_cur(cp_territory_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE) IS
3583: SELECT territory_short_name
3584: FROM FND_TERRITORIES_VL
3585: WHERE territory_code = UPPER(cp_territory_code);
3586:

Line 3584: FROM FND_TERRITORIES_VL

3580: WHERE person_id = cp_person_id;
3581:
3582: CURSOR terr_name_cur(cp_territory_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE) IS
3583: SELECT territory_short_name
3584: FROM FND_TERRITORIES_VL
3585: WHERE territory_code = UPPER(cp_territory_code);
3586:
3587: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
3588: l_territory_short_name FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

Line 3588: l_territory_short_name FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

3584: FROM FND_TERRITORIES_VL
3585: WHERE territory_code = UPPER(cp_territory_code);
3586:
3587: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
3588: l_territory_short_name FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
3589: BEGIN
3590:
3591:
3592: IF p_addr_rec.START_DATE IS NULL THEN