APPS.JE_BE_CSSR_PKG dependencies on GL_SETS_OF_BOOKS

Line 324: cursor get_coa_id (p_sob gl_sets_of_books.set_of_books_id%type)

320: l_ledger_id gl_ledgers.ledger_id%type;
321: l_bsv varchar2(30);
322:
323: -- ccid and sob
324: cursor get_coa_id (p_sob gl_sets_of_books.set_of_books_id%type)
325: is
326: select CHART_OF_ACCOUNTS_ID
327: from gl_sets_of_books
328: where set_of_books_id = p_sob;

Line 327: from gl_sets_of_books

323: -- ccid and sob
324: cursor get_coa_id (p_sob gl_sets_of_books.set_of_books_id%type)
325: is
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

Line 366: l_sob_id gl_sets_of_books.set_of_books_id%type;

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;
370: l_start_date date;

Line 375: l_sob_var gl_sets_of_books.set_of_books_id%type;

371: l_end_date date;
372: l_status_text varchar2(2000);
373: l_data_string varchar2(200);
374:
375: l_sob_var gl_sets_of_books.set_of_books_id%type;
376: l_string varchar2(2000);
377: l_qry_string varchar2(8000);
378: l_cntnt_prsnc_flag number(1);
379: