APPS.PAY_PYAUFBR_XMLP_PKG dependencies on FND_CURRENCIES

Line 47: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;

43: RETURN V_LEGISLATION_CODE;
44: END CF_LEGISLATION_CODEFORMULA;
45:
46: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
47: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
48: V_FORMAT_MASK VARCHAR2(100) := NULL;
49: V_FIELD_LENGTH NUMBER(3) := 15;
50: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
51: SELECT

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

46: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
47: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
48: V_FORMAT_MASK VARCHAR2(100) := NULL;
49: V_FIELD_LENGTH NUMBER(3) := 15;
50: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
51: SELECT
52: CURRENCY_CODE
53: FROM
54: FND_CURRENCIES

Line 54: FND_CURRENCIES

50: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
51: SELECT
52: CURRENCY_CODE
53: FROM
54: FND_CURRENCIES
55: WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;
56: BEGIN
57: OPEN CURRENCY_FORMAT_MASK(CF_LEGISLATION_CODE);
58: FETCH CURRENCY_FORMAT_MASK