APPS.FV_FACTS1_GL_PKG dependencies on FV_FACTS1_FED_ACCOUNTS

Line 127: FROM fv_facts1_fed_accounts

123:
124:
125: SELECT count(*)
126: INTO l_no_fed_account
127: FROM fv_facts1_fed_accounts
128: WHERE set_of_books_id = p_sob_id
129: AND fiscal_year = l_period_year;
130:
131:

Line 429: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and

425: FV_UTILITY.LOG_MESG('When others error in module: log: '||sqlerrm);
426: END log;
427: --------------------------------------------------------------------------------
428: -- Select all journal lines from gl_je_lines from the beginning of the year upto
429: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and
430: -- all journal lines not existing in fv_facts1_line_balances.
431: -- Retreives party info like party type, eliminations dept, etc and insert into
432: -- fv_facts1_line_balances.
433: --------------------------------------------------------------------------------

Line 459: TYPE fed_nonfed_t IS TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;

455: TYPE eliminations_dept_t IS TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;
456: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
457: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
458: TYPE account_number_t IS TABLE OF fv_facts1_line_balances.account_number%TYPE;
459: TYPE fed_nonfed_t IS TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;
460: TYPE g_ng_indicator_t IS TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;
461: TYPE record_category_t IS TABLE OF fv_facts1_line_balances.record_category%TYPE;
462: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);
463: TYPE period_num_t IS TABLE OF gl_period_statuses.period_num%TYPE;

Line 603: fv_facts1_fed_accounts fff,

599: if gbl_called_from_main = 'Y' then
600:
601: l_select_stmt := 'SELECT ' || l_select_stmt ||
602: ' FROM
603: fv_facts1_fed_accounts fff,
604: gl_code_combinations glcc,
605: ( SELECT period_num, period_name
606: FROM gl_period_statuses
607: WHERE application_id = 101

Line 641: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||

637:
638: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
639: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
640: glcc GL_CODE_COMBINATIONS_U1,
641: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
642: ' FROM fv_facts1_header_id_gt ftt
643: , gl_je_headers gjh
644: , gl_je_lines gjl
645: , (SELECT period_num

Line 653: , fv_facts1_fed_accounts fff

649: AND ledger_id = :gbl_sob_id
650: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
651: AND period_year = :gbl_period_year) gps
652: , gl_code_combinations glcc
653: , fv_facts1_fed_accounts fff
654: WHERE gjh.period_name = gps.period_name
655: AND gjl.ledger_id = :gbl_sob_id
656: AND gjl.je_header_id = ftt.je_header_id
657: AND gjh.currency_code <> ''STAT''

Line 1798: fv_utility.log_mesg('Updating fv_facts1_fed_accounts ' );

1794:
1795:
1796: --Update the fv_facts1_fed_account as processed as of date.
1797:
1798: fv_utility.log_mesg('Updating fv_facts1_fed_accounts ' );
1799: UPDATE fv_facts1_fed_accounts
1800: SET jc_flag = 'Y'
1801: WHERE set_of_books_id = gbl_sob_id
1802: AND fiscal_year = gbl_period_year;

Line 1799: UPDATE fv_facts1_fed_accounts

1795:
1796: --Update the fv_facts1_fed_account as processed as of date.
1797:
1798: fv_utility.log_mesg('Updating fv_facts1_fed_accounts ' );
1799: UPDATE fv_facts1_fed_accounts
1800: SET jc_flag = 'Y'
1801: WHERE set_of_books_id = gbl_sob_id
1802: AND fiscal_year = gbl_period_year;
1803: