APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on HR_ORGANIZATION_UNITS

Line 764: l_org_name HR_ORGANIZATION_UNITS.NAME%type;

760: --Local Variables for search results
761: l_rownum NUMBER;
762: l_emp_num mtl_employees_current_view.EMPLOYEE_NUM%type;
763: l_emp_name mtl_employees_current_view.FULL_NAME%type;
764: l_org_name HR_ORGANIZATION_UNITS.NAME%type;
765: l_start_date DATE;
766: l_end_date DATE;
767: l_org_id NUMBER;
768: l_emp_id NUMBER;

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

777: l_sql_string := l_sql_string || ' BRE.EFFECTIVE_END_DATE ,HOU.NAME ORG_NAME, ';
778: l_sql_string := l_sql_string || ' HOU.ORGANIZATION_ID,pf.employee_id EMPLOYEE_ID ';
779:
780: l_sql_string := l_sql_string || ' FROM mtl_employees_current_view pf, bom_resource_employees bre, ';
781: l_sql_string := l_sql_string || ' HR_ORGANIZATION_UNITS HOU, FND_USER FU ';
782:
783: l_sql_string := l_sql_string || ' WHERE pf.employee_id = bre.person_id ';
784: l_sql_string := l_sql_string || ' and pf.organization_id = bre.organization_id ';
785: l_sql_string := l_sql_string || ' and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE ';