DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PYSA dependencies on FND_TERRITORIES_VL

Line 645: FROM fnd_territories_vl

641: RETURN VARCHAR2
642: IS
643: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
644: SELECT territory_short_name
645: FROM fnd_territories_vl
646: WHERE territory_code = p_territory_code;
647: l_country fnd_territories_vl.territory_short_name%TYPE;
648: BEGIN
649: IF g_debug THEN

Line 647: l_country fnd_territories_vl.territory_short_name%TYPE;

643: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
644: SELECT territory_short_name
645: FROM fnd_territories_vl
646: WHERE territory_code = p_territory_code;
647: l_country fnd_territories_vl.territory_short_name%TYPE;
648: BEGIN
649: IF g_debug THEN
650: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);
651: END IF;