eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on MTL_EMPLOYEES_CURRENT_VIEW

Line 729: l_emp_num mtl_employees_current_view.EMPLOYEE_NUM%type;

725: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
726:
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;

Line 730: l_emp_name mtl_employees_current_view.FULL_NAME%type;

726:
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;

Line 747: l_sql_string := l_sql_string || ' FROM mtl_employees_current_view pf, bom_resource_employees bre, ';

743: l_sql_string := l_sql_string || ' PF.FULL_NAME EMP_NAME, BRE.EFFECTIVE_START_DATE , ';
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 ';

Line 1020: l_Emp_Number mtl_employees_current_view.employee_num%type;

1016:
1017: --Local Variables for search results
1018: l_rownum NUMBER ;
1019: l_Resource_ID NUMBER ;
1020: l_Emp_Number mtl_employees_current_view.employee_num%type;
1021: l_Emp_Name mtl_employees_current_view.full_name%type;
1022: l_Dept_ID NUMBER ;
1023: l_Emp_ID NUMBER ;
1024:

Line 1021: l_Emp_Name mtl_employees_current_view.full_name%type;

1017: --Local Variables for search results
1018: l_rownum NUMBER ;
1019: l_Resource_ID NUMBER ;
1020: l_Emp_Number mtl_employees_current_view.employee_num%type;
1021: l_Emp_Name mtl_employees_current_view.full_name%type;
1022: l_Dept_ID NUMBER ;
1023: l_Emp_ID NUMBER ;
1024:
1025:

Line 1032: l_sql_string := l_sql_string || ' FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri ';

1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1031: l_sql_string := 'SELECT rownum, A.* FROM ( SELECT DISTINCT bdri.resource_id ,pf.employee_num,pf.full_name, bdri.department_id,pf.employee_id ';
1032: l_sql_string := l_sql_string || ' FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri ';
1033: l_sql_string := l_sql_string || ' WHERE bre.instance_id = bdri.instance_id ';
1034: l_sql_string := l_sql_string || ' and pf.employee_id=bre.person_id ';
1035: l_sql_string := l_sql_string || ' and pf.organization_id = bre.organization_id ';
1036: l_sql_string := l_sql_string || ' and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE ';