APPS.JA_CN_COA_EXPORT_PKG dependencies on JA_CN_SUB_ACC_SOURCES_ALL

Line 378: ||' FROM Ja_Cn_Sub_Acc_Sources_All SYS_PAR '

374:
375: l_sql :=
376: 'SELECT '
377: ||' nvl(ACC_STR_V.concatenated_segments, '''') acc_str '
378: ||' FROM Ja_Cn_Sub_Acc_Sources_All SYS_PAR '
379: ||' ,' || l_account_structures_kfv || ' ACC_STR_V '
380: ||'WHERE ACC_STR_V.account_structure_id = SYS_PAR.ACCOUNTING_STRUCT_ID'
381: ||' AND SYS_PAR.CHART_OF_ACCOUNTS_ID = ' || l_coa_id --using parameter P_LE_ID
382: ;

Line 391: ,ja_cn_sub_acc_sources_all jcsasa

387: SELECT fifs.concatenated_segment_delimiter separator
388: INTO l_delimiter_label
389: FROM FND_ID_FLEX_STRUCTURES fifs
390: ,ja_cn_account_structures_kfv jcask
391: ,ja_cn_sub_acc_sources_all jcsasa
392: WHERE fifs.id_flex_num = jcask.structure_id
393: AND jcask.account_structure_id = jcsasa.accounting_struct_id
394: AND jcsasa.chart_of_accounts_id = pn_coa_id;
395: