APPS.FV_FACTS1_PKG dependencies on FV_FUND_GROUPS

Line 689: ln_fund_group_type fv_fund_groups.type%type ;

685: l_fund_group fv_treasury_symbols.fund_group_code%type;
686: l_fund_val fv_fund_parameters.fund_value%TYPE;
687: l_dept_id fv_treasury_symbols.department_id%TYPE;
688: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
689: ln_fund_group_type fv_fund_groups.type%type ;
690: ln_facts1_rollup fv_fund_groups.fund_group_code%TYPE;
691:
692: CURSOR fund_cur IS
693: SELECT ffp.fund_value fund_val, fts.fund_group_code fund_grp,

Line 690: ln_facts1_rollup fv_fund_groups.fund_group_code%TYPE;

686: l_fund_val fv_fund_parameters.fund_value%TYPE;
687: l_dept_id fv_treasury_symbols.department_id%TYPE;
688: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
689: ln_fund_group_type fv_fund_groups.type%type ;
690: ln_facts1_rollup fv_fund_groups.fund_group_code%TYPE;
691:
692: CURSOR fund_cur IS
693: SELECT ffp.fund_value fund_val, fts.fund_group_code fund_grp,
694: fts.department_id dep_id, fts.bureau_id bu_id

Line 724: FROM fv_fund_groups

720: -- Set the Fund Group
721: DECLARE
722: CURSOR facts1_rollup_cur IS
723: SELECT facts1_rollup
724: FROM fv_fund_groups
725: WHERE fund_group_code = l_fund_group
726: AND set_of_books_id = gbl_set_of_books_id;
727: BEGIN
728: ln_facts1_rollup := NULL;