APPS.FV_GTAS_GL_PKG dependencies on FV_GTAS_FED_ACCOUNTS

Line 170: FROM fv_gtas_fed_accounts

166:
167: IF gbl_err_code = 0 THEN
168: SELECT COUNT(*)
169: INTO l_no_fed_account
170: FROM fv_gtas_fed_accounts
171: WHERE set_of_books_id = p_sob_id
172: AND fiscal_year = gbl_period_year;
173:
174: log(l_module_name,'gbl_period_year: '||gbl_period_year);

Line 376: -- the period being run, for all accounts existing in fv_gtas_fed_accounts and

372: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
373: END get_segment_names;
374: --------------------------------------------------------------------------------
375: -- Select all journal lines from gl_je_lines from the beginning of the year upto
376: -- the period being run, for all accounts existing in fv_gtas_fed_accounts and
377: -- all journal lines not existing in fv_gtas_line_balances.
378: -- Retreives party info like party type, eliminations dept, etc and insert into
379: -- fv_gtas_line_balances.
380: --------------------------------------------------------------------------------

Line 422: TYPE sgl_account_number_list_t IS TABLE OF fv_gtas_fed_accounts.sgl_account_number%TYPE;

418: TYPE authority_type_flag_t IS TABLE OF VARCHAR2(1);
419: TYPE fed_nonfed_flag_list_t IS TABLE OF VARCHAR2(1);
420: TYPE budget_impact_ind_flag_list_t IS TABLE OF VARCHAR2(1);
421: TYPE trading_partner_flag_list_t IS TABLE OF VARCHAR2(1);
422: TYPE sgl_account_number_list_t IS TABLE OF fv_gtas_fed_accounts.sgl_account_number%TYPE;
423: --TYPE fed_nonfed_code_list_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;
424: TYPE authority_type_code_t IS TABLE OF fv_gtas_attributes.authority_type1%TYPE;
425: TYPE budget_impact_ind_t IS TABLE OF fv_gtas_attributes.bud_impact_ind1%TYPE;
426: TYPE doc_num_t IS TABLE OF fv_gtas_exceptions.doc_num%TYPE;

Line 576: fgf FV_GTAS_FED_ACCOUNTS_U1) */ ' ||

572: l_select_stmt :=
573: 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
574: FV_GTAS_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
575: glcc GL_CODE_COMBINATIONS_U1,
576: fgf FV_GTAS_FED_ACCOUNTS_U1) */ ' ||
577: l_select_stmt ||
578: ' FROM fv_gtas_header_id_gt ftt,
579: gl_je_headers gjh,
580: gl_je_lines gjl,

Line 588: fv_gtas_fed_accounts fgf

584: AND ledger_id = :gbl_sob_id
585: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
586: AND period_year = :gbl_period_year) gps,
587: gl_code_combinations glcc,
588: fv_gtas_fed_accounts fgf
589: , fv_fund_parameters ffp,
590: fv_treasury_symbols fts
591: WHERE gjh.period_name = gps.period_name
592: AND gjl.ledger_id = :gbl_sob_id

Line 2764: --Update the fv_gtas_fed_accounts as processed

2760: jc_run_month = gbl_period_num_high,
2761: run_fed_flag = 'J'
2762: WHERE set_of_books_id = gbl_sob_id
2763: AND fiscal_year = gbl_period_year;
2764: --Update the fv_gtas_fed_accounts as processed
2765: log(l_module_name, 'Updating fv_gtas_fed_accounts ' );
2766: UPDATE fv_gtas_fed_accounts
2767: SET jc_flag = 'Y'
2768: WHERE set_of_books_id = gbl_sob_id

Line 2765: log(l_module_name, 'Updating fv_gtas_fed_accounts ' );

2761: run_fed_flag = 'J'
2762: WHERE set_of_books_id = gbl_sob_id
2763: AND fiscal_year = gbl_period_year;
2764: --Update the fv_gtas_fed_accounts as processed
2765: log(l_module_name, 'Updating fv_gtas_fed_accounts ' );
2766: UPDATE fv_gtas_fed_accounts
2767: SET jc_flag = 'Y'
2768: WHERE set_of_books_id = gbl_sob_id
2769: AND fiscal_year = gbl_period_year;

Line 2766: UPDATE fv_gtas_fed_accounts

2762: WHERE set_of_books_id = gbl_sob_id
2763: AND fiscal_year = gbl_period_year;
2764: --Update the fv_gtas_fed_accounts as processed
2765: log(l_module_name, 'Updating fv_gtas_fed_accounts ' );
2766: UPDATE fv_gtas_fed_accounts
2767: SET jc_flag = 'Y'
2768: WHERE set_of_books_id = gbl_sob_id
2769: AND fiscal_year = gbl_period_year;
2770: