DBA Data[Home] [Help]

APPS.GMF_GMFINVAL_XMLP_PKG dependencies on GMF_FISCAL_POLICIES

Line 4: L_BASE_CURRENCY_CODE GMF_FISCAL_POLICIES.BASE_CURRENCY_CODE%TYPE;

1: PACKAGE BODY GMF_GMFINVAL_XMLP_PKG AS
2: /* $Header: GMFINVALB.pls 120.1.12020000.2 2012/07/24 14:41:09 spabolu ship $ */
3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4: L_BASE_CURRENCY_CODE GMF_FISCAL_POLICIES.BASE_CURRENCY_CODE%TYPE;
5: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS
6: SELECT
7: BASE_CURRENCY_CODE
8: FROM

Line 5: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS

1: PACKAGE BODY GMF_GMFINVAL_XMLP_PKG AS
2: /* $Header: GMFINVALB.pls 120.1.12020000.2 2012/07/24 14:41:09 spabolu ship $ */
3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4: L_BASE_CURRENCY_CODE GMF_FISCAL_POLICIES.BASE_CURRENCY_CODE%TYPE;
5: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS
6: SELECT
7: BASE_CURRENCY_CODE
8: FROM
9: GMF_FISCAL_POLICIES

Line 9: GMF_FISCAL_POLICIES

5: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS
6: SELECT
7: BASE_CURRENCY_CODE
8: FROM
9: GMF_FISCAL_POLICIES
10: WHERE LEGAL_ENTITY_ID = CP_LEGAL_ENTITY_ID;
11: BEGIN
12: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
13: OPEN CUR_CURRENCY_CODE(P_LEGAL_ENTITY_ID);

Line 233: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS

229: RETURN (BALANCECP);
230: END BALANCECFFORMULA;
231: FUNCTION CF_BASE_CURRENCYFORMULA RETURN VARCHAR2 IS
232: L_BASE_CURRENCY_CODE GL_PLCY_MST.BASE_CURRENCY_CODE%TYPE;
233: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS
234: SELECT
235: BASE_CURRENCY_CODE
236: FROM
237: GMF_FISCAL_POLICIES

Line 237: GMF_FISCAL_POLICIES

233: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS
234: SELECT
235: BASE_CURRENCY_CODE
236: FROM
237: GMF_FISCAL_POLICIES
238: WHERE LEGAL_ENTITY_ID = CP_LEGAL_ENTITY_ID;
239: BEGIN
240: OPEN CUR_CURRENCY_CODE(P_LEGAL_ENTITY_ID);
241: FETCH CUR_CURRENCY_CODE