APPS.AP_APXIAWRE_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 4: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;

1: PACKAGE BODY AP_APXIAWRE_XMLP_PKG AS
2: /* $Header: APXIAWREB.pls 120.0 2007/12/27 07:43:33 vjaganat 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.DESCRIPTION%TYPE;
8: BEGIN

Line 22: AP_SYSTEM_PARAMETERS P,

18: C.MINIMUM_ACCOUNTABLE_UNIT,
19: C.DESCRIPTION
20: INTO BASE_CURR,PREC,MIN_AU,DESCR
21: FROM
22: AP_SYSTEM_PARAMETERS P,
23: FND_CURRENCIES C
24: WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;
25: /*SRW.MESSAGE('4'
26: ,'2After Get_Base_Curr_Data')*/NULL;

Line 172: AP_SYSTEM_PARAMETERS;

168: SELECT
169: APPROVAL_TIMING
170: INTO P_APPROVAL_TIMING
171: FROM
172: AP_SYSTEM_PARAMETERS;
173: /*SRW.MESSAGE('7'
174: ,'After check flag')*/NULL;
175: IF (P_APPROVAL_TIMING in ('VALIDATED','ACCOUNTED')) THEN
176: LP_APPROVAL_TIMING := ' AND AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID,