APPS.JA_CN_EAB_EXPORT_PKG dependencies on JA_CN_SUB_ACC_SOURCES_ALL

Line 85: ||' FROM Ja_Cn_Sub_Acc_Sources_All SOURCE '

81: --Get the account structure from Source form
82: l_sql :=
83: 'SELECT '
84: ||' nvl(ACC_STR_V.concatenated_segments, '''') acc_str '
85: ||' FROM Ja_Cn_Sub_Acc_Sources_All SOURCE '
86: ||' ,' || l_account_structures_kfv || ' ACC_STR_V '
87: ||'WHERE ACC_STR_V.account_structure_id = SOURCE.ACCOUNTING_STRUCT_ID'
88: ||' AND SOURCE.CHART_OF_ACCOUNTS_ID = ' || l_coa_id --using variable l_coa_id
89: ;

Line 138: l_account_structure_id JA_CN_SUB_ACC_SOURCES_ALL.ACCOUNTING_STRUCT_ID%TYPE;

134: ,P_COA_ID IN NUMBER) IS
135:
136: l_procedure_name VARCHAR2(30) := 'Query_System_Options';
137: l_err_msg VARCHAR2(1000) := NULL;
138: l_account_structure_id JA_CN_SUB_ACC_SOURCES_ALL.ACCOUNTING_STRUCT_ID%TYPE;
139:
140: JA_CN_MISSING_BOOK_INFO exception;
141: l_msg_miss_book_info varchar2(2000);
142:

Line 144: l_coa_id JA_CN_SUB_ACC_SOURCES_ALL.Chart_Of_Accounts_Id%TYPE := P_COA_ID;

140: JA_CN_MISSING_BOOK_INFO exception;
141: l_msg_miss_book_info varchar2(2000);
142:
143: l_le_id JA_CN_SYSTEM_PARAMETERS_ALL.LEGAL_ENTITY_ID%TYPE := p_le_id;
144: l_coa_id JA_CN_SUB_ACC_SOURCES_ALL.Chart_Of_Accounts_Id%TYPE := P_COA_ID;
145: BEGIN
146: --log for debug
147: IF (g_proc_level >= g_dbg_level)
148: THEN

Line 172: from JA_CN_SUB_ACC_SOURCES_ALL sasc

168: WHERE jcsp.legal_entity_id = l_le_id ;
169:
170: select sasc.accounting_struct_id
171: into l_account_structure_id
172: from JA_CN_SUB_ACC_SOURCES_ALL sasc
173: where sasc.chart_of_accounts_id=l_coa_id;
174:
175: IF g_book_name is null OR g_company_name is null OR
176: g_book_num is null OR g_organization_id is null OR