APPS.JE_BE_CSSR_PKG dependencies on GL_PERIODS

Line 8: p_rep_period gl_periods.period_name%TYPE,

4: procedure main(
5: p_errbuf OUT NOCOPY VARCHAR2,
6: p_retcode OUT NOCOPY VARCHAR2,
7: p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE,
8: p_rep_period gl_periods.period_name%TYPE,
9: p_fax_number varchar2,
10: p_email varchar2,
11: p_resp_email varchar2,
12: p_trans_resp varchar2,

Line 330: cursor get_disp_period (l_rep_period gl_periods.period_name%type)

326: select CHART_OF_ACCOUNTS_ID
327: from gl_sets_of_books
328: where set_of_books_id = p_sob;
329:
330: cursor get_disp_period (l_rep_period gl_periods.period_name%type)
331: is
332: SELECT glp.period_year||'-'||decode(length(glp.period_num),2,to_char(glp.period_num),'0'||to_char(glp.period_num) ) period_num
333: ,glp.start_date
334: ,glp.end_date

Line 339: FROM gl_periods glp

335: ,acc.ledger_id
336: ,acc.BALANCING_SEGMENT_VALUE
337: ,acc.entity_level_code
338: ,legal.legal_entity_id
339: FROM gl_periods glp
340: ,jg_zz_vat_rep_entities legal
341: ,jg_zz_vat_rep_entities acc
342: WHERE glp.period_set_name = legal.tax_calendar_name
343: AND acc.vat_reporting_entity_id = p_vat_reporting_entity_id

Line 365: l_disp_period gl_periods.period_name%type;

361: l_disp_chr varchar2(200);
362: l_op_string varchar2(500);
363: l_rub varchar2(240);
364:
365: l_disp_period gl_periods.period_name%type;
366: l_sob_id gl_sets_of_books.set_of_books_id%type;
367: l_coa_id gl_code_combinations.CHART_OF_ACCOUNTS_ID%type;
368: l_seg_name fnd_id_flex_segments.application_column_name%type;
369: l_cc_id gl_code_combinations.code_combination_id%type;