APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on JA_CN_SUB_ACC_SOURCES_ALL

Line 640: FROM Ja_Cn_Sub_Acc_Sources_All

636: IF l_Project_Option = 'COA' THEN
637: --get application column name of project segment
638: SELECT Coa_Segment
639: INTO l_Project_Column_Name
640: FROM Ja_Cn_Sub_Acc_Sources_All
641: WHERE Chart_Of_Accounts_Id = l_Chart_Of_Accounts_Id;
642: l_Create_View_Sql := l_Create_View_Sql || 'gcc.' ||
643: l_Project_Column_Name || ' project_number,';
644: ELSE

Line 960: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%TYPE;

956: --p_Project_Option IN VARCHAR2, --Deleted by Chaoqun for CNAOV2
957: p_Request_Id IN NUMBER) IS
958:
959: l_Request_Id NUMBER;
960: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%TYPE;
961: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
962: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
963: l_Proc_Name VARCHAR2(100) := 'unitemize_journal_lines';
964:

Line 1452: FROM Ja_Cn_Sub_Acc_Sources_All Sas

1448: SELECT Sas.Project_Source_Flag,
1449: Sas.Project_Ac_Code,
1450: Sas.Project_Ac_Detail_Code,
1451: Sas.Ac_Grouping_Order--added for bug 6669665
1452: FROM Ja_Cn_Sub_Acc_Sources_All Sas
1453: WHERE Sas.Chart_Of_Accounts_Id = l_Chart_Of_Accounts_Id;*/
1454:
1455: --Deleted by Chaoqun end
1456:

Line 1977: FROM Ja_Cn_Sub_Acc_Sources_All

1973:
1974:
1975: /* CURSOR c_Project_Option IS
1976: SELECT Project_Source_Flag
1977: FROM Ja_Cn_Sub_Acc_Sources_All
1978: WHERE Chart_Of_Accounts_Id = l_Chart_Of_Accounts_Id;*/
1979:
1980: --End: Chaoqun updateed for CNAOV2 on 01-20-2010
1981: