APPS.FII_BUDGET_INTERFACE_PKG dependencies on FND_FLEX_VALUES

Line 63: FROM FND_ID_FLEX_SEGMENTS a, FND_SEGMENT_ATTRIBUTE_VALUES b, fnd_flex_values c,

59:
60: BEGIN
61: SELECT c.flex_value_id
62: INTO l_company
63: FROM FND_ID_FLEX_SEGMENTS a, FND_SEGMENT_ATTRIBUTE_VALUES b, fnd_flex_values c,
64: fnd_flex_values_tl d
65: WHERE a.ID_FLEX_CODE = 'GL#'
66: AND a.APPLICATION_ID = 101
67: AND a.ID_FLEX_NUM in (select chart_of_accounts_id from

Line 64: fnd_flex_values_tl d

60: BEGIN
61: SELECT c.flex_value_id
62: INTO l_company
63: FROM FND_ID_FLEX_SEGMENTS a, FND_SEGMENT_ATTRIBUTE_VALUES b, fnd_flex_values c,
64: fnd_flex_values_tl d
65: WHERE a.ID_FLEX_CODE = 'GL#'
66: AND a.APPLICATION_ID = 101
67: AND a.ID_FLEX_NUM in (select chart_of_accounts_id from
68: gl_ledgers_public_v where

Line 89: FROM FND_ID_FLEX_SEGMENTS a, FND_SEGMENT_ATTRIBUTE_VALUES b, fnd_flex_values c,

85:
86: BEGIN
87: SELECT c.flex_value_id
88: INTO l_cost_center
89: FROM FND_ID_FLEX_SEGMENTS a, FND_SEGMENT_ATTRIBUTE_VALUES b, fnd_flex_values c,
90: fnd_flex_values_tl d
91: WHERE a.ID_FLEX_CODE = 'GL#'
92: AND a.APPLICATION_ID = 101
93: AND a.ID_FLEX_NUM in (select chart_of_accounts_id from

Line 90: fnd_flex_values_tl d

86: BEGIN
87: SELECT c.flex_value_id
88: INTO l_cost_center
89: FROM FND_ID_FLEX_SEGMENTS a, FND_SEGMENT_ATTRIBUTE_VALUES b, fnd_flex_values c,
90: fnd_flex_values_tl d
91: WHERE a.ID_FLEX_CODE = 'GL#'
92: AND a.APPLICATION_ID = 101
93: AND a.ID_FLEX_NUM in (select chart_of_accounts_id from
94: gl_ledgers_public_v where

Line 115: FROM FND_ID_FLEX_SEGMENTS a, FND_SEGMENT_ATTRIBUTE_VALUES b, fnd_flex_values c,

111:
112: BEGIN
113: SELECT c.flex_value_id
114: INTO l_account
115: FROM FND_ID_FLEX_SEGMENTS a, FND_SEGMENT_ATTRIBUTE_VALUES b, fnd_flex_values c,
116: fnd_flex_values_tl d
117: WHERE a.ID_FLEX_CODE = 'GL#'
118: AND a.APPLICATION_ID = 101
119: AND a.ID_FLEX_NUM in (select chart_of_accounts_id from

Line 116: fnd_flex_values_tl d

112: BEGIN
113: SELECT c.flex_value_id
114: INTO l_account
115: FROM FND_ID_FLEX_SEGMENTS a, FND_SEGMENT_ATTRIBUTE_VALUES b, fnd_flex_values c,
116: fnd_flex_values_tl d
117: WHERE a.ID_FLEX_CODE = 'GL#'
118: AND a.APPLICATION_ID = 101
119: AND a.ID_FLEX_NUM in (select chart_of_accounts_id from
120: gl_ledgers_public_v where

Line 141: FROM fnd_flex_values f, fnd_flex_values_tl t, fii_financial_dimensions ffd

137: IF X_User_Defined_Dim is not null THEN
138: BEGIN
139: SELECT f.flex_value_id
140: INTO l_user_defined_dim
141: FROM fnd_flex_values f, fnd_flex_values_tl t, fii_financial_dimensions ffd
142: WHERE flex_value_set_id in
143: (SELECT MASTER_VALUE_SET_ID id FROM fii_financial_dimensions
144: WHERE dimension_short_name = 'FII_USER_DEFINED_1'
145: UNION