DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on FND_TERRITORIES_VL

Line 683: FROM fnd_territories_vl

679: RETURN VARCHAR2
680: IS
681: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
682: SELECT territory_short_name
683: FROM fnd_territories_vl
684: WHERE territory_code = p_territory_code;
685: l_country fnd_territories_vl.territory_short_name%TYPE;
686: BEGIN
687: IF g_debug THEN

Line 685: l_country fnd_territories_vl.territory_short_name%TYPE;

681: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
682: SELECT territory_short_name
683: FROM fnd_territories_vl
684: WHERE territory_code = p_territory_code;
685: l_country fnd_territories_vl.territory_short_name%TYPE;
686: BEGIN
687: IF g_debug THEN
688: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);
689: END IF;