APPS.JE_JEHUIAGE_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 4: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;

1: PACKAGE BODY JE_JEHUIAGE_XMLP_PKG AS
2: /* $Header: JEHUIAGEB.pls 120.2 2008/06/06 12:02:58 npannamp noship $ */
3: FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN IS
4: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
5: PREC FND_CURRENCIES.PRECISION%TYPE;
6: MIN_AU FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
8: BEGIN

Line 21: AP_SYSTEM_PARAMETERS P,

17: ,0),
18: C.DESCRIPTION
19: INTO BASE_CURR,PREC,MIN_AU,DESCR
20: FROM
21: AP_SYSTEM_PARAMETERS P,
22: FND_CURRENCIES_VL C
23: WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;
24: C_BASE_CURRENCY_CODE := BASE_CURR;
25: C_BASE_PRECISION := PREC;

Line 944: SQL_PROFILE := 'SELECT nvl(SORT_BY_ALTERNATE_FIELD ,' || '''N''' || ') INTO :SORT_BY_ALTERNATE FROM AP_SYSTEM_PARAMETERS';

940: /*SRW.MESSAGE(103
941: ,'Sort BY Altenate - AP Profile does not Exists')*/NULL;
942: END IF;
943: BEGIN
944: SQL_PROFILE := 'SELECT nvl(SORT_BY_ALTERNATE_FIELD ,' || '''N''' || ') INTO :SORT_BY_ALTERNATE FROM AP_SYSTEM_PARAMETERS';
945: EXECUTE IMMEDIATE
946: SQL_PROFILE;
947: /*SRW.MESSAGE(110
948: ,'Sort By Alternate' || SORT_BY_ALTERNATE)*/NULL;