APPS.FV_UPG_FACTS_EB_TO_GTAS dependencies on FV_FACTSII_ENDING_BALANCES

Line 57: FROM fv_factsii_ending_balances

53: WHERE fiscal_year = g_fiscal_year - 1;
54:
55: SELECT count(*)
56: INTO l_facts2_eb_count
57: FROM fv_factsii_ending_balances
58: WHERE fiscal_year = g_fiscal_year - 1;
59:
60: IF l_facts1_eb_count = 0 AND l_facts2_eb_count = 0 THEN
61: p_err_code := -1;

Line 639: FROM fv_factsii_ending_balances ff2e

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
640: WHERE ff2e.set_of_books_id = fgfa.set_of_books_id
641: AND ff2e.account = fgfa.account_number
642: AND ff2e.fiscal_year = g_fiscal_year - 1)
643: MINUS

Line 666: FROM fv_factsii_ending_balances

662: (ending_balance_dr - ending_balance_cr) amount,
663: DECODE(transfer_dept_id, NULL, NULL, 'F') fed_non_fed,
664: transfer_dept_id,
665: transfer_main_acct
666: FROM fv_factsii_ending_balances
667: WHERE set_of_books_id = v_sob_id
668: AND account = v_acct_number
669: AND fiscal_year = g_fiscal_year - 1;
670:

Line 882: FROM fv_factsii_ending_balances ff2e

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
882: FROM fv_factsii_ending_balances ff2e
883: WHERE ff2e.set_of_books_id = fgfa.set_of_books_id
884: AND ff2e.account = fgfa.account_number
885: AND ff2e.fiscal_year = g_fiscal_year - 1) UNION ALL
886: (SELECT account_number