APPS.PAY_PAYIEP30_XMLP_PKG dependencies on FND_CURRENCIES

Line 115: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;

111: RETURN V_LEGISLATION_CODE;
112: END CF_LEGISLATION_CODEFORMULA;
113:
114: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
115: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
116: V_FORMAT_MASK VARCHAR2(100) := NULL;
117: V_FIELD_LENGTH NUMBER(3) := 14;
118: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
119: SELECT

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

114: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
115: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
116: V_FORMAT_MASK VARCHAR2(100) := NULL;
117: V_FIELD_LENGTH NUMBER(3) := 14;
118: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
119: SELECT
120: CURRENCY_CODE
121: FROM
122: FND_CURRENCIES

Line 122: FND_CURRENCIES

118: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
119: SELECT
120: CURRENCY_CODE
121: FROM
122: FND_CURRENCIES
123: WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;
124: BEGIN
125: OPEN CURRENCY_FORMAT_MASK(CF_LEGISLATION_CODE);
126: FETCH CURRENCY_FORMAT_MASK