DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on FND_USER

Line 839: from fnd_user

835: IF (l_wlmti_last_upd_by <> -1) OR (l_wlmti_last_upd_by <> g_prev_upd_user_id) THEN
836: BEGIN
837: select user_name
838: into l_user_name
839: from fnd_user
840: where user_id = l_wlmti_last_upd_by
841: and sysdate between START_DATE and NVL(END_DATE,SYSDATE+1);
842: --***VJ Added for Performance Upgrade***--
843: EXCEPTION

Line 910: from fnd_user

906: IF (l_wlmti_last_upd_by <> l_wlmti_created_by) THEN
907: BEGIN
908: select user_name
909: into l_user_name
910: from fnd_user
911: where user_id = l_wlmti_created_by
912: and sysdate BETWEEN START_DATE and NVL(END_DATE,SYSDATE+1);
913: --***VJ Added for Performance Upgrade***--
914: EXCEPTION

Line 12538: FROM FND_USER FU

12534: l_stmt_num := 140;
12535: IF x_employee_id IS NULL THEN
12536: SELECT FU.employee_id
12537: INTO x_employee_id
12538: FROM FND_USER FU
12539: WHERE FU.user_id = p_user_id;
12540: END IF;
12541:
12542: l_stmt_num := 150;