DBA Data[Home] [Help]

APPS.FV_FUNDS_AVAILABLE_PKG dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 30: bud_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;

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

Line 31: bud_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;

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

Line 32: spd_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;

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

Line 33: spd_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;

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

Line 155: FROM fnd_flex_value_hierarchies

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