APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on GL_JE_BATCHES

Line 67: l_Batch_Name Gl_Je_Batches.NAME%TYPE;

63: --==========================================================================
64: PROCEDURE Get_Journal_Approver(p_Request_Id IN NUMBER) IS
65: l_Request_Id NUMBER := p_Request_Id;
66: l_Je_Header_Id NUMBER;
67: l_Batch_Name Gl_Je_Batches.NAME%TYPE;
68: l_Period_Name Gl_Periods.Period_Name%TYPE;
69: l_Approver VARCHAR2(100);
70: l_Approval_Status VARCHAR2(1);
71: l_Approver_Name VARCHAR2(100);

Line 88: FROM Gl_Je_Headers Jeh, Gl_Je_Batches Jeb

84: AND Gjs.LANGUAGE = Userenv('LANG')
85: AND Gjs.Journal_Approval_Flag = 'Y';
86: CURSOR c_Batch_Status IS
87: SELECT Jeb.Default_Period_Name, Jeb.NAME, Jeb.Approval_Status_Code
88: FROM Gl_Je_Headers Jeh, Gl_Je_Batches Jeb
89: WHERE Jeb.Je_Batch_Id = Jeh.Je_Batch_Id
90: AND Jeh.Je_Header_Id = l_Je_Header_Id;
91:
92: CURSOR c_Batch_Approver IS

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

976: FROM Gl_Je_Headers Jeh,
977: Gl_Je_Lines Jel,
978: Ja_Cn_Code_Combination_v Jcc,
979: Ja_Cn_Journals_Of_Period Jop,
980: Gl_Je_Batches Jeb--added by lyb, for bug 6654734
981: WHERE Jeh.Je_Header_Id = Jel.Je_Header_Id
982: AND Jcc.Ledger_Id = Jeh.Ledger_Id
983: AND Jcc.Code_Combination_Id = Jel.Code_Combination_Id
984: AND Jeh.Je_Header_Id = Jop.Je_Header_Id

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

1299: l_sql:=l_sql||' To_Number(NULL),';
1300: l_sql:=l_sql||' Jeh.Last_Updated_By)';*/
1301: l_sql:=l_sql||' FROM Gl_Je_Lines Jel,';
1302: l_sql:=l_sql||' Gl_Je_Headers Jeh,';
1303: l_sql:=l_sql||' Gl_Je_Batches Jeb,';
1304: l_sql:=l_sql||' Xla_Ae_Lines Ael,';
1305: l_sql:=l_sql||' Xla_Ae_Headers Aeh,';
1306: l_sql:=l_sql||' Gl_Import_References Gir,';
1307: l_sql:=l_sql||' Ja_Cn_Code_Combination_v Jcc,';

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

1440: -- To_Number(NULL),
1441: -- Jeh.Last_Updated_By)
1442: FROM Gl_Je_Lines Jel
1443: ,Gl_Je_Headers Jeh
1444: ,Gl_Je_Batches Jeb --added by lyb, for bug 6654734
1445: ,Xla_Ae_Lines Ael
1446: ,Xla_Ae_Headers Aeh
1447: ,Gl_Import_References Gir
1448: ,Ja_Cn_Code_Combination_v Jcc