APPS.JA_CN_HISDATA_MIG_PKG dependencies on GL_JE_HEADERS

Line 97: FROM gl_je_lines gjl, gl_je_headers gjh, ja_cn_dff_assignments jcda

93: ln_je_line_num NUMBER;
94: TYPE ref_cursor_type IS REF CURSOR;
95: cur_cash_lines ref_cursor_type;
96: lv_cur_cash_lines_sql VARCHAR2(4000) := 'SELECT gjl.je_header_id, gjl.je_line_num
97: FROM gl_je_lines gjl, gl_je_headers gjh, ja_cn_dff_assignments jcda
98: WHERE gjl.ledger_id = ' ||
99: pn_ledger_id || '
100: AND gjh.ledger_id = gjl.ledger_id
101: AND gjh.period_name = ''' ||

Line 294: Gl_Je_Headers Jeh,

290: UPDATE ja_cn_cfs_activities_all jcca
291: SET jcca.je_header_id =
292: (SELECT DISTINCT jcjl.je_header_id
293: FROM JA_CN_JOURNAL_LINES jcjl,
294: Gl_Je_Headers Jeh,
295: Xla_Ae_Lines Ael,
296: Gl_Import_References Gir
297: WHERE Jeh.Je_Header_Id = jcjl.je_header_id
298: AND Gir.Gl_Sl_Link_Id = Ael.Gl_Sl_Link_Id

Line 310: Gl_Je_Headers Jeh,

306: AND jcjl.period_name = pv_period_name),
307: jcca.je_line_num =
308: (SELECT DISTINCT jcjl.Je_Line_Num
309: FROM JA_CN_JOURNAL_LINES jcjl,
310: Gl_Je_Headers Jeh,
311: Xla_Ae_Lines Ael,
312: Gl_Import_References Gir
313: WHERE Jeh.Je_Header_Id = jcjl.je_header_id
314: AND Gir.Gl_Sl_Link_Id = Ael.Gl_Sl_Link_Id

Line 775: FROM Gl_Je_Headers Jeh,

771: UPDATE JA_CN_JOURNAL_LINES jc
772: SET currency_conversion_type =
773: (SELECT DISTINCT NVL(Ael.Currency_Conversion_Type,
774: Jeh.Currency_Conversion_Type) currency_conversion_type
775: FROM Gl_Je_Headers Jeh,
776: Xla_Ae_Lines Ael,
777: Gl_Import_References Gir,
778: JA_CN_JOURNAL_LINES jcjl
779: WHERE Jeh.Je_Header_Id = jcjl.je_header_id

Line 1735: FROM Gl_Je_Headers Jeh,

1731: UPDATE JA_CN_JOURNAL_LINES jc
1732: SET currency_conversion_type =
1733: (SELECT DISTINCT NVL(Ael.Currency_Conversion_Type,
1734: Jeh.Currency_Conversion_Type) currency_conversion_type
1735: FROM Gl_Je_Headers Jeh,
1736: Xla_Ae_Lines Ael,
1737: Gl_Import_References Gir,
1738: JA_CN_JOURNAL_LINES jcjl
1739: WHERE Jeh.Je_Header_Id = jcjl.je_header_id