APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on HR_ORGANIZATION_UNITS

Line 731: l_org_name HR_ORGANIZATION_UNITS.NAME%type;

727: --Local Variables for search results
728: l_rownum NUMBER;
729: l_emp_num mtl_employees_current_view.EMPLOYEE_NUM%type;
730: l_emp_name mtl_employees_current_view.FULL_NAME%type;
731: l_org_name HR_ORGANIZATION_UNITS.NAME%type;
732: l_start_date DATE;
733: l_end_date DATE;
734: l_org_id NUMBER;
735: l_emp_id NUMBER;

Line 748: l_sql_string := l_sql_string || ' HR_ORGANIZATION_UNITS HOU, FND_USER FU ';

744: l_sql_string := l_sql_string || ' BRE.EFFECTIVE_END_DATE ,HOU.NAME ORG_NAME, ';
745: l_sql_string := l_sql_string || ' HOU.ORGANIZATION_ID,pf.employee_id EMPLOYEE_ID ';
746:
747: l_sql_string := l_sql_string || ' FROM mtl_employees_current_view pf, bom_resource_employees bre, ';
748: l_sql_string := l_sql_string || ' HR_ORGANIZATION_UNITS HOU, FND_USER FU ';
749:
750: l_sql_string := l_sql_string || ' WHERE pf.employee_id = bre.person_id ';
751: l_sql_string := l_sql_string || ' and pf.organization_id = bre.organization_id ';
752: l_sql_string := l_sql_string || ' and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE ';