APPS.FV_YE_CLOSE dependencies on GL_JE_HEADERS

Line 3230: FROM GL_JE_HEADERS JEH

3226: GROUP BY eliminations_dept,g_ng_indicator;
3227:
3228: CURSOR CHK_SINGLE_LEDGER_CUR IS
3229: SELECT max(JEH.ledger_id)
3230: FROM GL_JE_HEADERS JEH
3231: WHERE JEH.je_batch_id = l_je_batch_id
3232: GROUP BY JEH.je_batch_id
3233: HAVING count(distinct JEH.ledger_id) = 1;
3234:

Line 3237: FROM GL_JE_HEADERS JEH

3233: HAVING count(distinct JEH.ledger_id) = 1;
3234:
3235: CURSOR CHK_ALC_EXISTS_CUR IS
3236: SELECT 1
3237: FROM GL_JE_HEADERS JEH
3238: WHERE JEH.je_batch_id = l_je_batch_id
3239: AND JEH.actual_flag <> 'B'
3240: AND JEH.reversed_je_header_id IS NULL
3241: AND EXISTS

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