DBA Data[Home] [Help]

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on GL_JE_HEADERS

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 367: ' FROM gl_je_headers jeh' ||

363: ' ,jeh.je_source' ||
364: ' ,bsv.legal_entity_id' || ',' ||
365: l_Request_Id ||
366: ',jeh.default_effective_date ' ||
367: ' FROM gl_je_headers jeh' ||
368: ' ,gl_je_lines jel' ||
369: ' ,gl_code_combinations gcc' ||
370: ' ,gl_periods gp' ||
371: ' ,gl_ledgers led' ||

Line 976: FROM Gl_Je_Headers Jeh,

972: -- Decode(Nvl(Jeh.Accrual_Rev_Status, 'N'),
973: -- 'R',
974: -- To_Number(NULL),
975: -- Jeh.Last_Updated_By)
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

Line 1302: l_sql:=l_sql||' Gl_Je_Headers Jeh,';

1298:
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,';

Line 1443: ,Gl_Je_Headers Jeh

1439: -- 'R',
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