eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_FUNDS_AVAILABLE_PKG dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 29: bud_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;

25: v_statement varchar2(100);
26: err_message varchar2(300);
27: acct_flex_id fnd_flex_values.flex_value_id%TYPE;
28: v_ca_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
29: bud_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
30: bud_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
31: spd_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
32: spd_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
33: x_period_num gl_period_statuses.period_num%TYPE;

Line 30: bud_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;

26: err_message varchar2(300);
27: acct_flex_id fnd_flex_values.flex_value_id%TYPE;
28: v_ca_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
29: bud_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
30: bud_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
31: spd_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
32: spd_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
33: x_period_num gl_period_statuses.period_num%TYPE;
34: v_segment_low_name number;

Line 31: spd_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;

27: acct_flex_id fnd_flex_values.flex_value_id%TYPE;
28: v_ca_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
29: bud_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
30: bud_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
31: spd_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
32: spd_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
33: x_period_num gl_period_statuses.period_num%TYPE;
34: v_segment_low_name number;
35: v_segment_num number;

Line 32: spd_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;

28: v_ca_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
29: bud_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
30: bud_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
31: spd_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
32: spd_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
33: x_period_num gl_period_statuses.period_num%TYPE;
34: v_segment_low_name number;
35: v_segment_num number;
36: v_segment_low_value varchar2(25);

Line 152: FROM fnd_flex_value_hierarchies

148: tot_packets number;
149:
150: CURSOR c_parent_value_spending IS
151: SELECT child_flex_value_low, child_flex_value_high
152: FROM fnd_flex_value_hierarchies
153: WHERE parent_flex_value = v_parent_value
154: AND flex_value_set_id = parent_value_id;
155: BEGIN
156: