APPS.CSE_COST_COLLECTOR dependencies on HR_ORGANIZATION_UNITS

Line 130: FROM hr_organization_units hr

126: AND mtt.type_class = 1;
127:
128: CURSOR org_name_cur (l_exp_org_id IN NUMBER) IS
129: SELECT name
130: FROM hr_organization_units hr
131: WHERE hr.organization_id = l_exp_org_id;
132:
133: CURSOR proj_number_cur (l_source_project_id IN NUMBER) IS
134: SELECT segment1

Line 468: hr_organization_units org

464: pa_expenditure_groups_all grp,
465: pa_expenditures_all exp,
466: pa_projects_all proj,
467: pa_tasks task,
468: hr_organization_units org
469: WHERE org.organization_id = NVL(item.override_to_organization_id,
470: exp.incurred_by_organization_id)
471: AND NVL(dist.reversed_flag, 'N') <> 'Y'
472: AND dist.cr_code_combination_id IS NOT NULL