DBA Data[Home] [Help]

APPS.IGS_PE_PERS_IMP_001 dependencies on FND_TERRITORIES_VL

Line 4268: FROM fnd_territories_vl

4264: AS
4265: CURSOR chk_cntry_code(cp_country_code VARCHAR2)
4266: IS
4267: SELECT territory_short_name
4268: FROM fnd_territories_vl
4269: WHERE territory_code = cp_country_code;
4270:
4271: l_country_name fnd_territories_vl.territory_short_name%TYPE ;
4272:

Line 4271: l_country_name fnd_territories_vl.territory_short_name%TYPE ;

4267: SELECT territory_short_name
4268: FROM fnd_territories_vl
4269: WHERE territory_code = cp_country_code;
4270:
4271: l_country_name fnd_territories_vl.territory_short_name%TYPE ;
4272:
4273: BEGIN
4274: l_country_name := NULL;
4275: