DBA Data[Home] [Help]

APPS.PAY_PYAUPYT_XMLP_PKG dependencies on FND_CURRENCIES

Line 199: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;

195: RETURN V_LEGISLATION_CODE;
196: END CF_LEGISLATION_CODEFORMULA;
197:
198: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
199: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
200: V_FORMAT_MASK VARCHAR2(100) := NULL;
201: V_FIELD_LENGTH NUMBER(3) := 30;
202: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
203: SELECT

Line 202: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS

198: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
199: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
200: V_FORMAT_MASK VARCHAR2(100) := NULL;
201: V_FIELD_LENGTH NUMBER(3) := 30;
202: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
203: SELECT
204: CURRENCY_CODE
205: FROM
206: FND_CURRENCIES

Line 206: FND_CURRENCIES

202: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
203: SELECT
204: CURRENCY_CODE
205: FROM
206: FND_CURRENCIES
207: WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;
208: BEGIN
209: OPEN CURRENCY_FORMAT_MASK(CF_LEGISLATION_CODE);
210: FETCH CURRENCY_FORMAT_MASK