APPS.FV_FACTS1_PKG dependencies on FV_FACTS1_PERIOD_BALANCES_V

Line 1515: FROM FV_FACTS1_PERIOD_BALANCES_V

1511: CURSOR edit_check_c IS
1512: SELECT fund_group, dept_id, bureau_id,
1513: SUM(DECODE(d_c_indicator, 'D', 0, NVL(amount, 0))) credit_amount,
1514: SUM(DECODE(d_c_indicator, 'C', 0, NVL(amount, 0))) debit_amount
1515: FROM FV_FACTS1_PERIOD_BALANCES_V
1516: WHERE set_of_books_id = p_set_of_books_id
1517: AND period_year = p_period_year
1518: and period_num <= p_period_num
1519: GROUP BY fund_group, dept_id, bureau_id;

Line 1644: FROM fv_facts1_period_balances_v t2

1640: 0,
1641: t2.ccid,
1642: t2.account_type,
1643: t2.recipient_name
1644: FROM fv_facts1_period_balances_v t2
1645: WHERE t2.set_of_books_id = gbl_set_of_books_id
1646: AND t2.end_bal_ind = 'Y'
1647: AND nvl(t2.amount,0) <> 0
1648: and period_year = gbl_fiscal_year

Line 1764: fv_facts1_period_balances_v fpb

1760: sum(decode(balance_type, 'G' , period_cr,
1761: decode(period_num , gbl_period_num_high,
1762: decode(sign(amount) , 1 , 0 , amount),0) ) ) period_dr
1763: from
1764: fv_facts1_period_balances_v fpb
1765: where fpb.set_of_books_id = gbl_set_of_books_id
1766: and fpb.period_year = gbl_fiscal_year
1767: and period_num <= gbl_period_num_high
1768: and fund_value between gbl_fund_range_low and gbl_fund_range_high