APPS.FV_YE_CLOSE dependencies on GL_PERIOD_STATUSES

Line 36: vg_closing_period Gl_Period_Statuses.period_name%TYPE;

32: vg_coa_id Gl_Sets_Of_Books.chart_of_accounts_id%TYPE;
33: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
34: vg_start_date Gl_Periods.start_date%TYPE;
35: vg_end_date Gl_Periods.end_date%TYPE;
36: vg_closing_period Gl_Period_Statuses.period_name%TYPE;
37: vg_coy_fyr Gl_Periods.period_year%TYPE;
38: vg_coy_start_date Gl_Periods.start_date%TYPE;
39: vg_coy_period Gl_Period_Statuses.period_name%TYPE;
40: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;

Line 39: vg_coy_period Gl_Period_Statuses.period_name%TYPE;

35: vg_end_date Gl_Periods.end_date%TYPE;
36: vg_closing_period Gl_Period_Statuses.period_name%TYPE;
37: vg_coy_fyr Gl_Periods.period_year%TYPE;
38: vg_coy_start_date Gl_Periods.start_date%TYPE;
39: vg_coy_period Gl_Period_Statuses.period_name%TYPE;
40: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
41: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
42: vg_acct_segnum NUMBER(4);
43: vg_bal_seg_val_opt_code gl_ledgers_public_v.bal_seg_value_option_code%TYPE;

Line 80: vg_closing_period_num Gl_Period_Statuses.period_num%TYPE;

76: vg_trf_main_acct_attribute fv_system_parameters.factsii_tr_main_acct_attribute%TYPE;
77:
78: vg_facts_attributes_setup BOOLEAN ;
79:
80: vg_closing_period_num Gl_Period_Statuses.period_num%TYPE;
81: ---------------------------------------------------------------------------------
82: ----------------------------------------------------------------
83: PROCEDURE insert_gl_interface_record(l_amount_dr IN NUMBER,
84: l_amount_cr IN NUMBER,

Line 460: FROM Gl_Period_Statuses

456: -- Get the Last Period of the Closing Fyr
457: BEGIN
458: SELECT period_name, period_num
459: INTO vg_closing_period, vg_closing_period_num
460: FROM Gl_Period_Statuses
461: WHERE ledger_id = vg_sob_id
462: AND application_id = 101
463: AND period_year = vp_closing_fyr
464: AND period_num = (SELECT MAX(period_num)

Line 465: FROM gl_period_statuses

461: WHERE ledger_id = vg_sob_id
462: AND application_id = 101
463: AND period_year = vp_closing_fyr
464: AND period_num = (SELECT MAX(period_num)
465: FROM gl_period_statuses
466: WHERE ledger_id = vg_sob_id
467: AND application_id = 101
468: AND period_year = vp_closing_fyr);
469:

Line 3428: FROM gl_period_statuses glp

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
3427: AND EXISTS (SELECT 1
3428: FROM gl_period_statuses glp
3429: WHERE glp.application_id = 101
3430: AND glp.set_of_books_id = :sob_id
3431: AND glp.ledger_id = :sob_id
3432: AND glp.period_year = :closing_fyr

Line 3457: FROM gl_period_statuses glp

3453: AND NVL(h.je_from_sla_flag, ''N'') = ''Y''
3454: --l.gl_sl_link_id is not null
3455: AND l.je_header_id = h.je_header_id
3456: AND EXISTS (SELECT 1
3457: FROM gl_period_statuses glp
3458: WHERE glp.application_id = 101
3459: AND glp.set_of_books_id = :sob_id
3460: AND glp.period_year = :closing_fyr
3461: AND glp.period_name = l.period_name)