DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on FND_USER

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

8: FUNCTION init_user_and_role(p_user_id IN VARCHAR2) RETURN VARCHAR2 IS
9: PRAGMA AUTONOMOUS_TRANSACTION;
10:
11: CURSOR get_user_id_csr(p_user_id IN VARCHAR2) IS
12: select user_id from fnd_user where user_name = p_user_id;
13:
14: l_user_id NUMBER;
15: l_resp_id NUMBER;
16:

Line 771: from jtf_notes_vl JTF,fnd_user fu

767: entered_date,
768: fu.employee_id entered_by,
769: (Select DISTINCT PF.full_name from mtl_employees_current_view PF where pf.employee_id =fu.employee_id) entered_by_name,
770: notes note
771: from jtf_notes_vl JTF,fnd_user fu
772: where source_object_code = 'AHL_WO_TURNOVER_NOTES'
773: and fu.user_id = JTF.entered_by
774: and source_object_id = p_WorkorderId ORDER BY entered_date DESC;
775: