APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on GL_JE_LINES

Line 329: FROM gl_je_lines jel

325: 'ATTRIBUTE15',jel.attribute15)
326: ) cash_related_item*/
327: jel.GLOBAL_ATTRIBUTE6 cash_related_item
328: INTO l_tr_csi_check
329: FROM gl_je_lines jel
330: , fun_trx_headers trxh
331: , fun_trx_lines trxl
332: , fun_dist_lines distl
333: -- ,ja_cn_dff_assignments dffa --

Line 691: l_je_line_num GL_JE_LINES.je_line_num%TYPE;

687: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
688: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
689: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
690: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
691: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
692: l_je_line_desc GL_JE_LINES.description%TYPE;
693: l_je_line_amount NUMBER;
694: l_je_line_func_amount NUMBER;
695: -- GL: Gl_JE_LINES

Line 692: l_je_line_desc GL_JE_LINES.description%TYPE;

688: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
689: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
690: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
691: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
692: l_je_line_desc GL_JE_LINES.description%TYPE;
693: l_je_line_amount NUMBER;
694: l_je_line_func_amount NUMBER;
695: -- GL: Gl_JE_LINES
696: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;

Line 695: -- GL: Gl_JE_LINES

691: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
692: l_je_line_desc GL_JE_LINES.description%TYPE;
693: l_je_line_amount NUMBER;
694: l_je_line_func_amount NUMBER;
695: -- GL: Gl_JE_LINES
696: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
697: l_cash_related_item varchar2(150); --cash related item of a line
698: l_cash_related_item_1 varchar2(150); --copy of cash related item of a line
699: l_csi_check varchar2(2); --blank or not of cash related item

Line 840: FROM GL_JE_LINES jel

836: ,nvl(jel.ENTERED_DR, 0) -
837: nvl(jel.ENTERED_CR, 0) je_entered_amount
838: ,nvl(jel.ACCOUNTED_DR, 0) -
839: nvl(jel.ACCOUNTED_CR, 0) je_accounted_amount
840: FROM GL_JE_LINES jel
841: ,GL_JE_HEADERS jeh
842: --,ja_cn_dff_assignments dffa
843: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
844: AND jeh.je_header_id = jel.je_header_id;

Line 1308: from GL_JE_LINES GL

1304: -- Get GL Journal header id and GL Journal line number for CNAO V2
1305: BEGIN
1306: Select gl.je_header_id, gl.je_line_num
1307: into l_je_header_id, l_je_line_num
1308: from GL_JE_LINES GL
1309: ,GL_JE_HEADERS GH
1310: where GL.REFERENCE_2 = l_trxb_batch_id
1311: and GL.REFERENCE_4 = l_trxl_id
1312: and GL.REFERENCE_5 = l_distl_id