APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on JA_CN_SUB_ACC_SOURCES_ALL

Line 344: from ja_cn_sub_acc_sources_all

340: --with the project flag of subsidiary account form.
341: if l_error_flag<>'Y' then
342: select nvl(project_source_flag,'-1'),nvl(history_coa_segment,'-1')
343: into l_project_flag,l_history_coa
344: from ja_cn_sub_acc_sources_all
345: where chart_of_accounts_id=l_coa;
346:
347: if l_project_flag='-1' then
348: update ja_cn_item_interface

Line 406: from ja_cn_sub_acc_sources_all

402: where ffv.flex_value_set_id=fifs.flex_value_set_id
403: and fifs.id_flex_code='GL#'
404: and fifs.id_flex_num=l_coa
405: and (fifs.application_column_name =(select coa_segment
406: from ja_cn_sub_acc_sources_all
407: where chart_of_accounts_id=l_coa
408: and coa_segment is not null)
409: or fifs.application_column_name =(select history_coa_segment
410: from ja_cn_sub_acc_sources_all

Line 410: from ja_cn_sub_acc_sources_all

406: from ja_cn_sub_acc_sources_all
407: where chart_of_accounts_id=l_coa
408: and coa_segment is not null)
409: or fifs.application_column_name =(select history_coa_segment
410: from ja_cn_sub_acc_sources_all
411: where chart_of_accounts_id=l_coa
412: and history_coa_segment is not null) )
413: AND flex_value = l_PROJECT_NUMBER ;
414: if l_count=0 then

Line 1515: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%type;

1511: l_Proc_Name VARCHAR2(100) := 'generate_code_combination_view';
1512: l_Second_Track_Col_Name VARCHAR2(30);
1513: l_Other_Cols_Name VARCHAR2(200);
1514: l_ledger_id number;
1515: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%type;
1516:
1517: cursor c_Project_Option is
1518: SELECT Project_Source_Flag
1519: FROM Ja_Cn_Sub_Acc_Sources_All ja,gl_ledgers gl

Line 1519: FROM Ja_Cn_Sub_Acc_Sources_All ja,gl_ledgers gl

1515: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%type;
1516:
1517: cursor c_Project_Option is
1518: SELECT Project_Source_Flag
1519: FROM Ja_Cn_Sub_Acc_Sources_All ja,gl_ledgers gl
1520: where ja.chart_of_accounts_id=gl.chart_of_accounts_id
1521: and gl.ledger_id=l_ledger_id;
1522:
1523:

Line 1625: FROM Ja_Cn_Sub_Acc_Sources_All ja,gl_ledgers gl

1621: IF l_Project_Option = 'COA' THEN
1622: --get application column name of project segment
1623: SELECT Coa_Segment
1624: INTO l_Project_Column_Name
1625: FROM Ja_Cn_Sub_Acc_Sources_All ja,gl_ledgers gl
1626: WHERE ja.Chart_Of_Accounts_Id =gl.Chart_Of_Accounts_Id
1627: and gl.ledger_id=l_ledger_id;
1628: l_Create_View_Sql := l_Create_View_Sql || 'gcc.' ||
1629: l_Project_Column_Name || ' project_number,';

Line 2438: from ja_cn_sub_acc_sources_all

2434: where ffv.flex_value_set_id=fifs.flex_value_set_id
2435: and fifs.id_flex_code='GL#'
2436: and fifs.id_flex_num=l_coa
2437: and (fifs.application_column_name =(select coa_segment
2438: from ja_cn_sub_acc_sources_all
2439: where chart_of_accounts_id=l_coa
2440: and coa_segment is not null)
2441: or fifs.application_column_name =(select history_coa_segment
2442: from ja_cn_sub_acc_sources_all

Line 2442: from ja_cn_sub_acc_sources_all

2438: from ja_cn_sub_acc_sources_all
2439: where chart_of_accounts_id=l_coa
2440: and coa_segment is not null)
2441: or fifs.application_column_name =(select history_coa_segment
2442: from ja_cn_sub_acc_sources_all
2443: where chart_of_accounts_id=l_coa
2444: and history_coa_segment is not null) )
2445: AND flex_value = l_PROJECT_NUMBER ;
2446: end if;