APPS.CSE_COST_COLLECTOR dependencies on HR_ORGANIZATION_UNITS

Line 117: FROM hr_organization_units hr

113: AND mtt.type_class = 1;
114:
115: CURSOR org_name_cur (l_exp_org_id IN NUMBER) IS
116: SELECT name
117: FROM hr_organization_units hr
118: WHERE hr.organization_id = l_exp_org_id;
119:
120: CURSOR proj_number_cur (l_source_project_id IN NUMBER) IS
121: SELECT segment1

Line 455: hr_organization_units org

451: pa_expenditure_groups_all grp,
452: pa_expenditures_all exp,
453: pa_projects_all proj,
454: pa_tasks task,
455: hr_organization_units org
456: WHERE org.organization_id = NVL(item.override_to_organization_id,
457: exp.incurred_by_organization_id)
458: AND NVL(dist.reversed_flag, 'N') <> 'Y'
459: AND dist.cr_code_combination_id IS NOT NULL