APPS.FV_FACTS1_PKG dependencies on FV_FACTS1_PERIOD_BALANCES_V

Line 1543: FROM FV_FACTS1_PERIOD_BALANCES_V

1539: CURSOR edit_check_c IS
1540: SELECT fund_group, dept_id, bureau_id,
1541: SUM(DECODE(d_c_indicator, 'D', 0, NVL(amount, 0))) credit_amount,
1542: SUM(DECODE(d_c_indicator, 'C', 0, NVL(amount, 0))) debit_amount
1543: FROM FV_FACTS1_PERIOD_BALANCES_V
1544: WHERE set_of_books_id = p_set_of_books_id
1545: AND period_year = p_period_year
1546: and period_num <= p_period_num
1547: GROUP BY fund_group, dept_id, bureau_id;

Line 1684: FROM fv_facts1_period_balances_v t2

1680: 0,
1681: t2.ccid,
1682: t2.account_type,
1683: t2.recipient_name
1684: FROM fv_facts1_period_balances_v t2
1685: WHERE t2.set_of_books_id = gbl_set_of_books_id
1686: AND t2.end_bal_ind = 'Y'
1687: AND nvl(t2.amount,0) <> 0
1688: and period_year = gbl_fiscal_year

Line 1805: fv_facts1_period_balances_v fpb

1801: sum(decode(balance_type, 'G' , period_cr,
1802: decode(period_num , gbl_period_num_high,
1803: decode(sign(amount) , 1 , 0 , amount),0) ) ) period_dr
1804: from
1805: fv_facts1_period_balances_v fpb
1806: where fpb.set_of_books_id = gbl_set_of_books_id
1807: and fpb.period_year = gbl_fiscal_year
1808: and period_num <= gbl_period_num_high
1809: and fund_value between gbl_fund_range_low and gbl_fund_range_high