DBA Data[Home] [Help]

APPS.AR_ARBRRMLT_XMLP_PKG dependencies on FND_TERRITORIES_VL

Line 117: FND_TERRITORIES_VL

113: SELECT
114: TERRITORY_SHORT_NAME
115: INTO COUNTRY_DESCRIPTION
116: FROM
117: FND_TERRITORIES_VL
118: WHERE TERRITORY_CODE = COUNTRY_CODE;
119: IF COUNTRY_DESCRIPTION IS NULL THEN
120: COUNTRY_DESCRIPTION := COUNTRY_CODE;
121: END IF;

Line 128: FND_TERRITORIES_VL

124: SELECT
125: TERRITORY_SHORT_NAME
126: INTO COUNTRY_DESCRIPTION
127: FROM
128: FND_TERRITORIES_VL
129: WHERE TERRITORY_CODE = COUNTRY_CODE;
130: ELSE
131: COUNTRY_DESCRIPTION := NULL;
132: END IF;