DBA Data[Home] [Help]

APPS.FV_FUNDS_AVAILABLE_PKG dependencies on FV_FUND_PARAMETERS

Line 10: v_budget fv_fund_parameters.budget_authority%TYPE;

6:
7: /*******************************************************************/
8: /***** Variable Declaration For All Processes ******/
9: /*******************************************************************/
10: v_budget fv_fund_parameters.budget_authority%TYPE;
11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:

Line 11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;

7: /*******************************************************************/
8: /***** Variable Declaration For All Processes ******/
9: /*******************************************************************/
10: v_budget fv_fund_parameters.budget_authority%TYPE;
11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;

Line 12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;

8: /***** Variable Declaration For All Processes ******/
9: /*******************************************************************/
10: v_budget fv_fund_parameters.budget_authority%TYPE;
11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;

Line 13: v_expenditure fv_fund_parameters.expended_amount%TYPE;

9: /*******************************************************************/
10: v_budget fv_fund_parameters.budget_authority%TYPE;
11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
17: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;

Line 15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;

11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
17: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
18: v_fund_value fv_fund_parameters.fund_value%TYPE;
19: v_acct_seg_name varchar2(30);

Line 16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;

12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
17: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
18: v_fund_value fv_fund_parameters.fund_value%TYPE;
19: v_acct_seg_name varchar2(30);
20: v_bal_seg_name varchar2(30);

Line 18: v_fund_value fv_fund_parameters.fund_value%TYPE;

14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
17: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
18: v_fund_value fv_fund_parameters.fund_value%TYPE;
19: v_acct_seg_name varchar2(30);
20: v_bal_seg_name varchar2(30);
21: bud_authority_type varchar2(50);
22:

Line 120: FROM fv_fund_parameters fp

116: fp.unliquid_obligations,
117: fp.expended_amount,
118: fp.transfers_in,
119: fp.transfers_out
120: FROM fv_fund_parameters fp
121: WHERE fp.set_of_books_id = sob_id
122: and decode(rollup_type,'F',fp.fund_value,'T',treasury_symbol_id)
123: between decode(rollup_type,
124: 'T',temp_v_treasury_symbol_id,