DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on FND_TERRITORIES_VL

Line 781: FROM fnd_territories_vl

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

Line 784: l_country fnd_territories_vl.territory_short_name%TYPE;

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