DBA Data[Home] [Help]

APPS.XLA_TACCOUNTS_DATA_PKG dependencies on GL_CODE_COMBINATIONS

Line 111: g_account_type GL_CODE_COMBINATIONS.account_type%TYPE;

107: g_closingBalanceCr NUMBER := 0;
108:
109: g_currency_cnt NUMBER := 0;
110: g_currency_code FND_CURRENCIES.currency_code%TYPE;
111: g_account_type GL_CODE_COMBINATIONS.account_type%TYPE;
112: g_period_name VARCHAR2(30);
113: g_current_account VARCHAR2(255);
114: g_current_Ccid NUMBER;
115: g_accountingCurrency FND_CURRENCIES.currency_code%TYPE;

Line 157: g_tb_account_type GL_CODE_COMBINATIONS.account_type%TYPE;

153: g_tb_closingBalanceCr NUMBER := 0;
154:
155: g_tb_currency_cnt NUMBER := 0;
156: g_tb_currency_code FND_CURRENCIES.currency_code%TYPE;
157: g_tb_account_type GL_CODE_COMBINATIONS.account_type%TYPE;
158: g_tb_period_name VARCHAR2(30);
159: g_tb_current_account VARCHAR2(255);
160: g_tb_current_Ccid NUMBER;
161:

Line 919: l_from_clause := 'FROM GL_CODE_COMBINATIONS GLCC,'||p_viewName||' AEL_V';

915:
916: -- Build From clause
917: IF (p_Application_Id <> 101 )
918: THEN
919: l_from_clause := 'FROM GL_CODE_COMBINATIONS GLCC,'||p_viewName||' AEL_V';
920: ELSIF ( p_Application_Id = 101 ) THEN
921: l_from_clause := 'FROM GL_CODE_COMBINATIONS GLCC, XLA_GL_JE_AEL_V AEL_V';
922: END IF;
923:

Line 921: l_from_clause := 'FROM GL_CODE_COMBINATIONS GLCC, XLA_GL_JE_AEL_V AEL_V';

917: IF (p_Application_Id <> 101 )
918: THEN
919: l_from_clause := 'FROM GL_CODE_COMBINATIONS GLCC,'||p_viewName||' AEL_V';
920: ELSIF ( p_Application_Id = 101 ) THEN
921: l_from_clause := 'FROM GL_CODE_COMBINATIONS GLCC, XLA_GL_JE_AEL_V AEL_V';
922: END IF;
923:
924: -- Build Where clause
925: