DBA Data[Home] [Help]

APPS.PER_PERSACTR_XMLP_PKG dependencies on FND_CURRENCIES

Line 52: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;

48: RETURN V_LEGISLATION_CODE;
49: END CF_LEGISLATION_CODEFORMULA;
50:
51: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
52: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
53: V_FORMAT_MASK VARCHAR2(100) := NULL;
54: V_FIELD_LENGTH NUMBER(3) := 14;
55: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
56: SELECT

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

51: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
52: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
53: V_FORMAT_MASK VARCHAR2(100) := NULL;
54: V_FIELD_LENGTH NUMBER(3) := 14;
55: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
56: SELECT
57: CURRENCY_CODE
58: FROM
59: FND_CURRENCIES

Line 59: FND_CURRENCIES

55: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
56: SELECT
57: CURRENCY_CODE
58: FROM
59: FND_CURRENCIES
60: WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;
61: BEGIN
62: OPEN CURRENCY_FORMAT_MASK(CF_LEGISLATION_CODE);
63: FETCH CURRENCY_FORMAT_MASK