APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on GL_JE_BATCHES

Line 86: l_Batch_Name Gl_Je_Batches.NAME%TYPE;

82: --==========================================================================
83: PROCEDURE Get_Journal_Approver(p_Request_Id IN NUMBER) IS
84: l_Request_Id NUMBER := p_Request_Id;
85: l_Je_Header_Id NUMBER;
86: l_Batch_Name Gl_Je_Batches.NAME%TYPE;
87: l_Period_Name Gl_Periods.Period_Name%TYPE;
88: l_Approver VARCHAR2(100);
89: l_Approval_Status VARCHAR2(1);
90: l_Approver_Name VARCHAR2(100);

Line 107: FROM Gl_Je_Headers Jeh, Gl_Je_Batches Jeb

103: AND Gjs.LANGUAGE = Userenv('LANG')
104: AND Gjs.Journal_Approval_Flag = 'Y';
105: CURSOR c_Batch_Status IS
106: SELECT Jeb.Default_Period_Name, Jeb.NAME, Jeb.Approval_Status_Code
107: FROM Gl_Je_Headers Jeh, Gl_Je_Batches Jeb
108: WHERE Jeb.Je_Batch_Id = Jeh.Je_Batch_Id
109: AND Jeh.Je_Header_Id = l_Je_Header_Id;
110:
111: CURSOR c_Batch_Approver IS

Line 1141: l_sql:=l_sql||' Gl_Je_Batches Jeb ';

1137: l_sql:=l_sql||' FROM Gl_Je_Headers Jeh,';
1138: l_sql:=l_sql||' Gl_Je_Lines Jel,';
1139: l_sql:=l_sql||' Ja_Cn_Code_Combination_v Jcc,';
1140: l_sql:=l_sql||' Ja_Cn_Journals_Of_Period Jop,';
1141: l_sql:=l_sql||' Gl_Je_Batches Jeb ';
1142: l_sql:=l_sql||' WHERE Jeh.Je_Header_Id = Jel.Je_Header_Id';
1143: l_sql:=l_sql||' AND Jcc.Ledger_Id = Jeh.Ledger_Id';
1144: l_sql:=l_sql||' AND Jcc.Code_Combination_Id = Jel.Code_Combination_Id';
1145: l_sql:=l_sql||' AND Jeh.Je_Header_Id = Jop.Je_Header_Id';

Line 1242: Gl_Je_Batches Jeb--added by lyb, for bug 6654734

1238: FROM Gl_Je_Headers Jeh,
1239: Gl_Je_Lines Jel,
1240: Ja_Cn_Code_Combination_v Jcc,
1241: Ja_Cn_Journals_Of_Period Jop,
1242: Gl_Je_Batches Jeb--added by lyb, for bug 6654734
1243: WHERE Jeh.Je_Header_Id = Jel.Je_Header_Id
1244: AND Jcc.Ledger_Id = Jeh.Ledger_Id
1245: AND Jcc.Code_Combination_Id = Jel.Code_Combination_Id
1246: AND Jeh.Je_Header_Id = Jop.Je_Header_Id

Line 1714: l_sql:=l_sql||' Gl_Je_Batches Jeb,';

1710: l_sql:=l_sql||' To_Number(NULL),';
1711: l_sql:=l_sql||' Jeh.Last_Updated_By)';*/
1712: l_sql:=l_sql||' FROM Gl_Je_Lines Jel,';
1713: l_sql:=l_sql||' Gl_Je_Headers Jeh,';
1714: l_sql:=l_sql||' Gl_Je_Batches Jeb,';
1715: l_sql:=l_sql||' Xla_Ae_Lines Ael,';
1716: l_sql:=l_sql||' Xla_Ae_Headers Aeh,';
1717: l_sql:=l_sql||' Gl_Import_References Gir,';
1718: l_sql:=l_sql||' Ja_Cn_Code_Combination_v Jcc,';

Line 1859: ,Gl_Je_Batches Jeb --added by lyb, for bug 6654734

1855: -- To_Number(NULL),
1856: -- Jeh.Last_Updated_By)
1857: FROM Gl_Je_Lines Jel
1858: ,Gl_Je_Headers Jeh
1859: ,Gl_Je_Batches Jeb --added by lyb, for bug 6654734
1860: ,Xla_Ae_Lines Ael
1861: ,Xla_Ae_Headers Aeh
1862: ,Gl_Import_References Gir
1863: ,Ja_Cn_Code_Combination_v Jcc