DBA Data[Home] [Help]

APPS.FII_BUDGET_BASE_UPG_C dependencies on FND_FLEX_VALUES

Line 27: FROM FND_FLEX_VALUES

23: END IF;
24:
25: SELECT flex_value_id
26: INTO l_unassigned_id
27: FROM FND_FLEX_VALUES
28: WHERE flex_value_set_id =
29: (SELECT flex_value_set_id
30: FROM FND_FLEX_VALUE_SETS
31: WHERE flex_value_set_name

Line 106: , FND_FLEX_VALUES fv1

102: , fv1.flex_value_id company_id
103: , fv2.flex_value_id cost_center_id
104: FROM HR_ORGANIZATION_INFORMATION ccc_tbl
105: , HR_ORGANIZATION_INFORMATION org
106: , FND_FLEX_VALUES fv1
107: , FND_FLEX_VALUES fv2
108: WHERE ccc_tbl.org_information_context = 'CLASS'
109: AND ccc_tbl.org_information1 = 'CC'
110: AND ccc_tbl.org_information2 = 'Y'

Line 107: , FND_FLEX_VALUES fv2

103: , fv2.flex_value_id cost_center_id
104: FROM HR_ORGANIZATION_INFORMATION ccc_tbl
105: , HR_ORGANIZATION_INFORMATION org
106: , FND_FLEX_VALUES fv1
107: , FND_FLEX_VALUES fv2
108: WHERE ccc_tbl.org_information_context = 'CLASS'
109: AND ccc_tbl.org_information1 = 'CC'
110: AND ccc_tbl.org_information2 = 'Y'
111: AND org.org_information_context = 'Company Cost Center'