eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_UPG_FACTS_EB_TO_GTAS dependencies on FV_GTAS_FED_ACCOUNTS

Line 456: FROM fv_gtas_fed_accounts fgfa

452: l_module VARCHAR2(200) := g_module || 'PROCESS_FACTS1_EB.';
453: --Fetch accounts existing in FACTS I ending balances
454: CURSOR facts1_acct_cur IS
455: SELECT DISTINCT account_number, set_of_books_id
456: FROM fv_gtas_fed_accounts fgfa
457: WHERE fiscal_year = g_fiscal_year
458: AND fed_non_fed_flag = 'Y'
459: AND EXISTS
460: (SELECT 1

Line 635: FROM fv_gtas_fed_accounts fgfa

631: SELECT DISTINCT account_number,
632: set_of_books_id,
633: authority_type_flag,
634: fed_non_fed_flag
635: FROM fv_gtas_fed_accounts fgfa
636: WHERE fiscal_year = g_fiscal_year
637: AND (fed_non_fed_flag = 'Y' OR authority_type_flag = 'Y')
638: AND EXISTS((SELECT account
639: FROM fv_factsii_ending_balances ff2e

Line 877: FROM fv_gtas_fed_accounts fgfa

873:
874: CURSOR fed_acct_not_in_facts_cur IS
875: SELECT DISTINCT account_number, sgl_account_number, set_of_books_id,
876: authority_type_flag
877: FROM fv_gtas_fed_accounts fgfa
878: WHERE fiscal_year = g_fiscal_year
879: AND (fgfa.fed_non_fed_flag = 'Y' OR
880: fgfa.authority_type_flag = 'Y')
881: AND NOT EXISTS((SELECT account