APPS.FV_YE_CARRYFORWARD dependencies on GL_PERIODS

Line 20: vp_carryfor_fyr Gl_Periods.period_year%TYPE ;

16: -- ======================================================================
17: vp_errbuf VARCHAR2(1000) ;
18: vp_retcode NUMBER := 0 ;
19: vp_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE ;
20: vp_carryfor_fyr Gl_Periods.period_year%TYPE ;
21: -- ======================================================================
22: -- Other Global Variable Declarations
23: -- ======================================================================
24: vg_coa_id Gl_Sets_Of_Books.chart_of_accounts_id%TYPE;

Line 31: vg_closing_fyr Gl_Periods.period_year%TYPE;

27: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
28: vg_closing_period Gl_Period_Statuses.period_name%TYPE;
29: vg_carryfor_period Gl_Period_Statuses.period_name%TYPE;
30: vg_start_date Gl_Period_Statuses.start_date%TYPE;
31: vg_closing_fyr Gl_Periods.period_year%TYPE;
32: vg_jrnl_group_id NUMBER;
33: vg_interface_run_id NUMBER;
34: vg_bal_seg_val_opt_code VARCHAR2(1);
35: vg_acct_seg_name varchar2(250);

Line 626: FROM gl_periods

622: AND xl.gl_sl_link_id = gir.gl_sl_link_id
623: AND xl.currency_code = h.currency_code
624: AND NVL(h.je_from_sla_flag, ''N'') = ''Y''
625: AND EXISTS (SELECT 1
626: FROM gl_periods
627: WHERE period_year = :closing_fyr
628: AND period_set_name = :period_set_name
629: AND period_name = l.period_name)
630: AND nvl(xdl.SOURCE_DISTRIBUTION_ID_NUM_1,-99)=b.transaction_id(+)

Line 667: FROM gl_periods

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'')
666: AND EXISTS (SELECT 1
667: FROM gl_periods
668: WHERE period_year = :closing_fyr
669: AND period_set_name = :period_set_name
670: AND period_name = l.period_name)
671: AND nvl(Fv_Ye_Carryforward.Convert_To_Num(l.reference_1),-99)=b.transaction_id(+)