APPS.PAY_AE_ARCHIVE dependencies on FND_TERRITORIES_VL

Line 790: FROM fnd_territories_vl

786: IS
787:
788: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
789: SELECT territory_short_name
790: FROM fnd_territories_vl
791: WHERE territory_code = p_territory_code;
792:
793: l_country fnd_territories_vl.territory_short_name%TYPE;
794: BEGIN

Line 793: l_country fnd_territories_vl.territory_short_name%TYPE;

789: SELECT territory_short_name
790: FROM fnd_territories_vl
791: WHERE territory_code = p_territory_code;
792:
793: l_country fnd_territories_vl.territory_short_name%TYPE;
794: BEGIN
795:
796: IF g_debug THEN
797: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);