DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on FND_TERRITORIES_VL

Line 780: FROM fnd_territories_vl

776: IS
777:
778: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
779: SELECT territory_short_name
780: FROM fnd_territories_vl
781: WHERE territory_code = p_territory_code;
782:
783: l_country fnd_territories_vl.territory_short_name%TYPE;
784: BEGIN

Line 783: l_country fnd_territories_vl.territory_short_name%TYPE;

779: SELECT territory_short_name
780: FROM fnd_territories_vl
781: WHERE territory_code = p_territory_code;
782:
783: l_country fnd_territories_vl.territory_short_name%TYPE;
784: BEGIN
785:
786: IF g_debug THEN
787: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);