APPS.FV_YE_CLOSE dependencies on GL_PERIOD_STATUSES

Line 39: vg_closing_period Gl_Period_Statuses.period_name%TYPE;

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

Line 42: vg_coy_period Gl_Period_Statuses.period_name%TYPE;

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

Line 88: vg_closing_period_num Gl_Period_Statuses.period_num%TYPE;

84: vg_trf_main_acct_attribute fv_system_parameters.factsii_tr_main_acct_attribute%TYPE;
85:
86: vg_facts_attributes_setup BOOLEAN ;
87:
88: vg_closing_period_num Gl_Period_Statuses.period_num%TYPE;
89: ---------------------------------------------------------------------------------
90: ----------------------------------------------------------------
91: PROCEDURE insert_gl_interface_record(l_amount_dr IN NUMBER,
92: l_amount_cr IN NUMBER,

Line 145: from gl_period_statuses

141: vp_closing_method := closing_method;
142: vg_closing_period := closing_period;
143:
144: select period_num into vp_closing_num
145: from gl_period_statuses
146: where application_id = 101
147: and set_of_books_id = vg_sob_id
148: and period_name = closing_period
149: and period_year = closing_fyr;

Line 3517: FROM gl_period_statuses glp

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
3516: AND EXISTS (SELECT 1
3517: FROM gl_period_statuses glp
3518: WHERE glp.application_id = 101
3519: AND glp.set_of_books_id = :sob_id
3520: AND glp.ledger_id = :sob_id
3521: AND glp.period_year = :closing_fyr

Line 3546: FROM gl_period_statuses glp

3542: AND NVL(h.je_from_sla_flag, ''N'') = ''Y''
3543: --l.gl_sl_link_id is not null
3544: AND l.je_header_id = h.je_header_id
3545: AND EXISTS (SELECT 1
3546: FROM gl_period_statuses glp
3547: WHERE glp.application_id = 101
3548: AND glp.set_of_books_id = :sob_id
3549: AND glp.period_year = :closing_fyr
3550: AND glp.period_name = l.period_name)