DBA Data[Home] [Help]

APPS.PAY_NL_GENERAL dependencies on FND_TERRITORIES_VL

Line 1338: l_territory_name fnd_territories_vl.territory_short_name%TYPE;

1334: ------------------------------------------------------------------
1335: FUNCTION get_country_name(p_territory_code IN VARCHAR2)
1336: RETURN VARCHAR2 IS
1337:
1338: l_territory_name fnd_territories_vl.territory_short_name%TYPE;
1339:
1340: CURSOR c_territory_name IS
1341: SELECT ter.territory_short_name
1342: FROM fnd_territories_vl ter

Line 1342: FROM fnd_territories_vl ter

1338: l_territory_name fnd_territories_vl.territory_short_name%TYPE;
1339:
1340: CURSOR c_territory_name IS
1341: SELECT ter.territory_short_name
1342: FROM fnd_territories_vl ter
1343: WHERE ter.territory_code = p_territory_code;
1344:
1345: BEGIN
1346: OPEN c_territory_name;