APPS.FV_YE_CLOSE dependencies on GL_JE_LINES

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

3507: vl_stmt :=
3508: ' SELECT MAX(Fv_Ye_Carryforward.Convert_To_Num (l.reference_1)) reference_1 ,
3509: SUM( NVL(entered_dr, 0) - NVL(entered_cr,0) ) line_amount ' ||
3510: vl_attribute_cols ||
3511: ' FROM gl_je_lines l , fv_be_trx_dtls B, gl_je_headers h
3512: WHERE l.code_combination_id = :ccid
3513: AND l.je_header_id = h.je_header_id
3514: AND NVL(h.je_from_sla_flag, ''N'') IN (''N'',''U'')
3515: -- AND l.gl_sl_link_id is null

Line 3534: gl_je_lines l, gl_je_headers h, gl_import_references gli

3530: SELECT MAX(xdl.SOURCE_DISTRIBUTION_ID_NUM_1) reference_1 ,
3531: SUM( NVL(xl.entered_dr, 0) - NVL(xl.entered_cr,0) ) line_amount '
3532: ||vl_attribute_cols ||
3533: ' FROM fv_be_trx_dtls B, xla_ae_lines xl , xla_distribution_links xdl,
3534: gl_je_lines l, gl_je_headers h, gl_import_references gli
3535: WHERE xl.code_combination_id = :ccid
3536: AND xl.ae_header_id = xdl.ae_header_id
3537: AND xl.ae_line_num = xdl.ae_line_num
3538: AND xl.gl_sl_link_id = gli.gl_sl_link_id

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

4013: l_trf_main_acct IN VARCHAR2)
4014:
4015: IS
4016:
4017: TYPE attribtable IS TABLE OF gl_je_lines.attribute1%TYPE
4018: INDEX BY BINARY_INTEGER;
4019: vl_attribtable attribtable ;
4020:
4021: vl_str VARCHAR2(3000);