DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_UMFR dependencies on FND_TERRITORIES_VL

Line 1098: FROM fnd_territories_vl

1094: IS
1095: CURSOR csr_get_territory_name (p_territory_code VARCHAR2)
1096: IS
1097: SELECT territory_short_name
1098: FROM fnd_territories_vl
1099: WHERE territory_code = p_territory_code;
1100:
1101: l_country fnd_territories_vl.territory_short_name%TYPE;
1102: BEGIN

Line 1101: l_country fnd_territories_vl.territory_short_name%TYPE;

1097: SELECT territory_short_name
1098: FROM fnd_territories_vl
1099: WHERE territory_code = p_territory_code;
1100:
1101: l_country fnd_territories_vl.territory_short_name%TYPE;
1102: BEGIN
1103: IF g_debug
1104: THEN
1105: hr_utility.set_location (' Entering Function GET_COUNTRY_NAME', 140);