DBA Data[Home] [Help]

APPS.FV_STATUS_OF_FUNDS_PKG dependencies on GL_BALANCES

Line 31: sob_id gl_balances.ledger_id%TYPE;

27: bal_seg_name_num number(2);
28: acct_ff_low varchar2(2000);
29: acct_ff_high varchar2(2000);
30: acct_seg_name_num number(2);
31: sob_id gl_balances.ledger_id%TYPE;
32: sob_id1 gl_balances.ledger_id%TYPE;
33: curr_code gl_balances.currency_code%TYPE;
34: pd_name gl_balances.period_name%TYPE;
35: v_value_low varchar2(60);

Line 32: sob_id1 gl_balances.ledger_id%TYPE;

28: acct_ff_low varchar2(2000);
29: acct_ff_high varchar2(2000);
30: acct_seg_name_num number(2);
31: sob_id gl_balances.ledger_id%TYPE;
32: sob_id1 gl_balances.ledger_id%TYPE;
33: curr_code gl_balances.currency_code%TYPE;
34: pd_name gl_balances.period_name%TYPE;
35: v_value_low varchar2(60);
36: v_value_high varchar2(60);

Line 33: curr_code gl_balances.currency_code%TYPE;

29: acct_ff_high varchar2(2000);
30: acct_seg_name_num number(2);
31: sob_id gl_balances.ledger_id%TYPE;
32: sob_id1 gl_balances.ledger_id%TYPE;
33: curr_code gl_balances.currency_code%TYPE;
34: pd_name gl_balances.period_name%TYPE;
35: v_value_low varchar2(60);
36: v_value_high varchar2(60);
37: acct_seg_name varchar2(25);

Line 34: pd_name gl_balances.period_name%TYPE;

30: acct_seg_name_num number(2);
31: sob_id gl_balances.ledger_id%TYPE;
32: sob_id1 gl_balances.ledger_id%TYPE;
33: curr_code gl_balances.currency_code%TYPE;
34: pd_name gl_balances.period_name%TYPE;
35: v_value_low varchar2(60);
36: v_value_high varchar2(60);
37: acct_seg_name varchar2(25);
38: bal_seg_name varchar2(25);

Line 112: FROM gl_BALANCES glB,

108: 'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
109: 'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
110: 'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
111: 'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg3
112: FROM gl_BALANCES glB,
113: gl_code_combinations glc
114: WHERE glb.code_combination_id = glc.code_combination_id
115: AND glc.chart_of_accounts_id = v_ca_id
116: AND glb.ledger_id = sob_id

Line 248: FROM gl_BALANCES glB,

244: 'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
245: 'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
246: 'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
247: 'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg3
248: FROM gl_BALANCES glB,
249: gl_code_combinations glc
250: WHERE glb.code_combination_id = glc.code_combination_id
251: AND glc.chart_of_accounts_id = v_ca_id
252: AND glb.ledger_id = sob_id

Line 384: FROM gl_balances glB,

380: 'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
381: 'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
382: 'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
383: 'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg3
384: FROM gl_balances glB,
385: gl_code_combinations glc
386: WHERE glb.code_combination_id = glc.code_combination_id
387: AND glc.chart_of_accounts_id = v_ca_id
388: AND glb.ledger_id = sob_id

Line 778: sob_id1 IN gl_balances.ledger_id%TYPE,

774: /******************************************************************/
775: PROCEDURE sum_children_budget
776: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
777: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
778: sob_id1 IN gl_balances.ledger_id%TYPE,
779: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
780: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
781: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE ) --Changed to Fix 1575992
782: Is

Line 933: sob_id1 IN gl_balances.ledger_id%TYPE,

929: PROCEDURE sum_children_transfers
930: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
931: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
932: v_trans_type IN VARCHAR2,
933: sob_id1 IN gl_balances.ledger_id%TYPE,
934: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
935: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
936: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE )--Added to fix bug.1575992
937:

Line 1131: sob_id1 IN gl_balances.ledger_id%TYPE,

1127: PROCEDURE sum_children_spending
1128: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
1129: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
1130: v_spend_type IN varchar2,
1131: sob_id1 IN gl_balances.ledger_id%TYPE,
1132: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
1133: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
1134: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE )
1135: