eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_YE_CARRYFORWARD dependencies on GL_JE_HEADERS

Line 371: vl_header_id Gl_Je_Headers.je_header_id%TYPE;

367: -- journal entries have been reversed or not.
368: -- ------------------------------------------------------------------
369: PROCEDURE Check_Carryforward_Process IS
370: vl_cnt NUMBER;
371: vl_header_id Gl_Je_Headers.je_header_id%TYPE;
372: vl_accrrev_status Gl_Je_Headers.accrual_rev_status%TYPE;
373: vl_rev_header_id Gl_Je_Headers.accrual_rev_je_header_id%TYPE;
374: vl_rev_status Gl_Je_Headers.status%TYPE;
375: vl_status Gl_Je_Headers.status%TYPE;

Line 372: vl_accrrev_status Gl_Je_Headers.accrual_rev_status%TYPE;

368: -- ------------------------------------------------------------------
369: PROCEDURE Check_Carryforward_Process IS
370: vl_cnt NUMBER;
371: vl_header_id Gl_Je_Headers.je_header_id%TYPE;
372: vl_accrrev_status Gl_Je_Headers.accrual_rev_status%TYPE;
373: vl_rev_header_id Gl_Je_Headers.accrual_rev_je_header_id%TYPE;
374: vl_rev_status Gl_Je_Headers.status%TYPE;
375: vl_status Gl_Je_Headers.status%TYPE;
376: CURSOR get_count_cur IS

Line 373: vl_rev_header_id Gl_Je_Headers.accrual_rev_je_header_id%TYPE;

369: PROCEDURE Check_Carryforward_Process IS
370: vl_cnt NUMBER;
371: vl_header_id Gl_Je_Headers.je_header_id%TYPE;
372: vl_accrrev_status Gl_Je_Headers.accrual_rev_status%TYPE;
373: vl_rev_header_id Gl_Je_Headers.accrual_rev_je_header_id%TYPE;
374: vl_rev_status Gl_Je_Headers.status%TYPE;
375: vl_status Gl_Je_Headers.status%TYPE;
376: CURSOR get_count_cur IS
377: SELECT COUNT(*)

Line 374: vl_rev_status Gl_Je_Headers.status%TYPE;

370: vl_cnt NUMBER;
371: vl_header_id Gl_Je_Headers.je_header_id%TYPE;
372: vl_accrrev_status Gl_Je_Headers.accrual_rev_status%TYPE;
373: vl_rev_header_id Gl_Je_Headers.accrual_rev_je_header_id%TYPE;
374: vl_rev_status Gl_Je_Headers.status%TYPE;
375: vl_status Gl_Je_Headers.status%TYPE;
376: CURSOR get_count_cur IS
377: SELECT COUNT(*)
378: FROM Gl_Je_Headers

Line 375: vl_status Gl_Je_Headers.status%TYPE;

371: vl_header_id Gl_Je_Headers.je_header_id%TYPE;
372: vl_accrrev_status Gl_Je_Headers.accrual_rev_status%TYPE;
373: vl_rev_header_id Gl_Je_Headers.accrual_rev_je_header_id%TYPE;
374: vl_rev_status Gl_Je_Headers.status%TYPE;
375: vl_status Gl_Je_Headers.status%TYPE;
376: CURSOR get_count_cur IS
377: SELECT COUNT(*)
378: FROM Gl_Je_Headers
379: WHERE ledger_id = vp_sob_id

Line 378: FROM Gl_Je_Headers

374: vl_rev_status Gl_Je_Headers.status%TYPE;
375: vl_status Gl_Je_Headers.status%TYPE;
376: CURSOR get_count_cur IS
377: SELECT COUNT(*)
378: FROM Gl_Je_Headers
379: WHERE ledger_id = vp_sob_id
380: AND je_source = 'Year End Close'
381: AND je_category = 'Federal Carry Forward'
382: AND period_name = vg_carryfor_period;

Line 386: FROM Gl_Je_Headers

382: AND period_name = vg_carryfor_period;
383: CURSOR get_hdrs_cur IS
384: SELECT je_header_id,accrual_rev_status,
385: accrual_rev_je_header_id,status
386: FROM Gl_Je_Headers
387: WHERE ledger_id = vp_sob_id
388: AND je_source = 'Year End Close'
389: AND je_category = 'Federal Carry Forward'
390: AND period_name = vg_carryfor_period;

Line 393: FROM Gl_Je_Headers

389: AND je_category = 'Federal Carry Forward'
390: AND period_name = vg_carryfor_period;
391: CURSOR get_revstat_cur IS
392: SELECT status
393: FROM Gl_Je_Headers
394: WHERE ledger_id = vp_sob_id
395: AND je_header_id = vl_rev_header_id;
396: l_module_name VARCHAR2(200);
397: BEGIN

Line 606: gl_je_headers h , gl_code_combinations gcc,

602: || ' MAX(xdl.SOURCE_DISTRIBUTION_ID_NUM_1) reference_1 '
603: || vl_attribute_cols || '
604: FROM fv_be_trx_dtls B, xla_ae_lines xl ,
605: xla_distribution_links xdl, gl_je_lines l,
606: gl_je_headers h , gl_code_combinations gcc,
607: gl_import_references gir
608: WHERE l.code_combination_id = gcc.code_combination_id
609: AND l.je_header_id = h.je_header_id
610:

Line 661: FROM gl_je_lines l , fv_be_trx_dtls b, gl_je_headers h , gl_code_combinations gcc

657: || vg_coa_id
658: || ' , gcc.code_combination_id , '
659: || ' MAX(fv_ye_carryforward.convert_to_num(l.reference_1)) '
660: || vl_attribute_cols || '
661: FROM gl_je_lines l , fv_be_trx_dtls b, gl_je_headers h , gl_code_combinations gcc
662: WHERE l.code_combination_id = gcc.code_combination_id
663: AND FV_YE_CARRYFORWARD.Check_bal_seg_value(GCC.'|| VG_BAL_SEG_VALUE||', :sob_id,:bal_seg_val_opt_code ) = '||''''||'Y'||''''||
664: ' AND l.je_header_id = h.je_header_id
665: AND NVL(h.je_from_sla_flag, ''N'') IN (''N'',''U'')