APPS.FV_YE_CLOSE dependencies on GL_JE_LINES

Line 3422: ' FROM gl_je_lines l , fv_be_trx_dtls B, gl_je_headers h

3418: vl_stmt :=
3419: ' SELECT MAX(Fv_Ye_Carryforward.Convert_To_Num (l.reference_1)) reference_1 ,
3420: SUM( NVL(entered_dr, 0) - NVL(entered_cr,0) ) line_amount ' ||
3421: vl_attribute_cols ||
3422: ' FROM gl_je_lines l , fv_be_trx_dtls B, gl_je_headers h
3423: WHERE l.code_combination_id = :ccid
3424: AND l.je_header_id = h.je_header_id
3425: AND NVL(h.je_from_sla_flag, ''N'') IN (''N'',''U'')
3426: -- AND l.gl_sl_link_id is null

Line 3445: gl_je_lines l, gl_je_headers h, gl_import_references gli

3441: SELECT MAX(xdl.SOURCE_DISTRIBUTION_ID_NUM_1) reference_1 ,
3442: SUM( NVL(xl.entered_dr, 0) - NVL(xl.entered_cr,0) ) line_amount '
3443: ||vl_attribute_cols ||
3444: ' FROM fv_be_trx_dtls B, xla_ae_lines xl , xla_distribution_links xdl,
3445: gl_je_lines l, gl_je_headers h, gl_import_references gli
3446: WHERE xl.code_combination_id = :ccid
3447: AND xl.ae_header_id = xdl.ae_header_id
3448: AND xl.ae_line_num = xdl.ae_line_num
3449: AND xl.gl_sl_link_id = gli.gl_sl_link_id

Line 3815: TYPE attribtable IS TABLE OF gl_je_lines.attribute1%TYPE

3811: l_trf_main_acct IN VARCHAR2)
3812:
3813: IS
3814:
3815: TYPE attribtable IS TABLE OF gl_je_lines.attribute1%TYPE
3816: INDEX BY BINARY_INTEGER;
3817: vl_attribtable attribtable ;
3818:
3819: vl_str VARCHAR2(3000);