100: , (SELECT /*+ no_merge */
101: ccc_tbl.organization_id
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'
101: ccc_tbl.organization_id
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'