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 762: l_emp_num mtl_employees_current_view.EMPLOYEE_NUM%type;

758: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
759:
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;

Line 763: l_emp_name mtl_employees_current_view.FULL_NAME%type;

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

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

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

Line 1053: l_Emp_Number mtl_employees_current_view.employee_num%type;

1049:
1050: --Local Variables for search results
1051: l_rownum NUMBER ;
1052: l_Resource_ID NUMBER ;
1053: l_Emp_Number mtl_employees_current_view.employee_num%type;
1054: l_Emp_Name mtl_employees_current_view.full_name%type;
1055: l_Dept_ID NUMBER ;
1056: l_Emp_ID NUMBER ;
1057:

Line 1054: l_Emp_Name mtl_employees_current_view.full_name%type;

1050: --Local Variables for search results
1051: l_rownum NUMBER ;
1052: l_Resource_ID NUMBER ;
1053: l_Emp_Number mtl_employees_current_view.employee_num%type;
1054: l_Emp_Name mtl_employees_current_view.full_name%type;
1055: l_Dept_ID NUMBER ;
1056: l_Emp_ID NUMBER ;
1057:
1058:

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

1061: x_return_status := FND_API.G_RET_STS_SUCCESS;
1062:
1063: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1064: l_sql_string := 'SELECT * FROM ( SELECT rownum RN, bdri.resource_id ,pf.employee_num,pf.full_name, bdri.department_id,pf.employee_id ';
1065: l_sql_string := l_sql_string || ' FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri ';
1066: l_sql_string := l_sql_string || ' WHERE bre.instance_id = bdri.instance_id ';
1067: l_sql_string := l_sql_string || ' and pf.employee_id=bre.person_id ';
1068: l_sql_string := l_sql_string || ' and pf.organization_id = bre.organization_id ';
1069: l_sql_string := l_sql_string || ' and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE ';