[Home] [Help]
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
383: ' ,jeh.je_source' ||
384: ' ,bsv.legal_entity_id' || ',' ||
385: l_Request_Id ||
386: ',jeh.default_effective_date ' ||
387: ' FROM gl_je_headers jeh' ||
388: ' ,gl_je_lines jel' ||
389: ' ,gl_code_combinations gcc' ||
390: ' ,gl_periods gp' ||
391: ' ,gl_ledgers led' ||
1133: l_sql:=l_sql||l_Request_Id||', ';
1134: l_sql:=l_sql||' Jeh.Created_By,';
1135: l_sql:=l_sql||' Jeb.Posted_By, ';
1136: l_sql:=l_sql|| l_SM_Query_Header_Sql; -- Added for fetching settlement method
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 ';
1234: -- Decode(Nvl(Jeh.Accrual_Rev_Status, 'N'),
1235: -- 'R',
1236: -- To_Number(NULL),
1237: -- Jeh.Last_Updated_By)
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
1709:
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,';
1854: -- 'R',
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