APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on FND_USER

Line 22: select user_id from fnd_user where user_name = p_user_id;

18:
19: FUNCTION init_user_and_role(p_user_id IN VARCHAR2) RETURN VARCHAR2 IS
20:
21: CURSOR get_user_id_csr(p_user_id IN VARCHAR2) IS
22: select user_id from fnd_user where user_name = p_user_id;
23:
24: l_user_id NUMBER;
25: l_resp_id NUMBER;
26:

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 ';