APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on JA_CN_SUB_ACC_SOURCES_ALL

Line 557: FROM Ja_Cn_Sub_Acc_Sources_All

553: IF l_Project_Option = 'COA' THEN
554: --get application column name of project segment
555: SELECT Coa_Segment
556: INTO l_Project_Column_Name
557: FROM Ja_Cn_Sub_Acc_Sources_All
558: WHERE Chart_Of_Accounts_Id = l_Chart_Of_Accounts_Id;
559: l_Create_View_Sql := l_Create_View_Sql || 'gcc.' ||
560: l_Project_Column_Name || ' project_number,';
561: ELSE

Line 871: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%TYPE;

867: PROCEDURE Unitemize_Journal_Lines(p_Project_Option IN VARCHAR2,
868: p_Request_Id IN NUMBER) IS
869:
870: l_Request_Id NUMBER;
871: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%TYPE;
872: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
873: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
874: l_Proc_Name VARCHAR2(100) := 'unitemize_journal_lines';
875:

Line 1171: FROM Ja_Cn_Sub_Acc_Sources_All Sas

1167: SELECT Sas.Project_Source_Flag,
1168: Sas.Project_Ac_Code,
1169: Sas.Project_Ac_Detail_Code,
1170: Sas.Ac_Grouping_Order--added for bug 6669665
1171: FROM Ja_Cn_Sub_Acc_Sources_All Sas
1172: WHERE Sas.Chart_Of_Accounts_Id = l_Chart_Of_Accounts_Id;
1173:
1174: BEGIN
1175: --log for debug

Line 1544: FROM Ja_Cn_Sub_Acc_Sources_All

1540: l_Post_Fail EXCEPTION;
1541:
1542: CURSOR c_Project_Option IS
1543: SELECT Project_Source_Flag
1544: FROM Ja_Cn_Sub_Acc_Sources_All
1545: WHERE Chart_Of_Accounts_Id = l_Chart_Of_Accounts_Id;
1546:
1547: CURSOR c_Period_Name IS
1548: SELECT Gp.Period_Name