APPS.PSP_LABOR_DIST dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4068: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

4064: */
4065:
4066:
4067: l_organization_id NUMBER(15);
4068: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4069: l_gl_code_combination_id NUMBER(15);
4070: l_project_id NUMBER(15);
4071: l_task_id NUMBER(15);
4072: l_award_id NUMBER(15);

Line 7962: hr_all_organization_units hou

7958: paf.assignment_number,
7959: hou.name
7960: from per_all_people_f ppf,
7961: per_all_assignments_f paf,
7962: hr_all_organization_units hou
7963: where ppf.person_id = p_person_id
7964: and p_eff_date between ppf.effective_start_date and ppf.effective_end_date
7965: and paf.assignment_type = 'E'
7966: and paf.assignment_id = p_assignment_id