DBA Data[Home] [Help]

APPS.MSC_X_WFNOTIFY_PKG dependencies on WF_USERS

Line 483: FROM wf_users

479:
480: SELECT substr(display_name,instr(display_name,',')+ 1) || ' ' ||
481: substr(display_name,1, instr(display_name,',') -1)
482: INTO l_real_name
483: FROM wf_users
484: WHERE name = l_user_performer;
485: exception
486: when others then
487: l_real_name := null;

Line 637: FROM wf_users

633:
634: SELECT substr(display_name,instr(display_name,',')+ 1) || ' ' ||
635: substr(display_name,1, instr(display_name,',') -1)
636: INTO l_real_name
637: FROM wf_users
638: WHERE name = l_user_performer;
639: exception
640: when others then
641: l_real_name := null;

Line 809: FROM wf_users

805:
806: SELECT substr(display_name,instr(display_name,',')+ 1) || ' ' ||
807: substr(display_name,1, instr(display_name,',') -1)
808: INTO l_real_name
809: FROM wf_users
810: WHERE name = l_user_performer;
811: exception
812: when others then
813: l_real_name := null;

Line 1788: FROM wf_users

1784:
1785: SELECT substr(display_name,instr(display_name,',')+ 1) || ' ' ||
1786: substr(display_name,1, instr(display_name,',') -1)
1787: INTO l_real_name
1788: FROM wf_users
1789: WHERE name = l_user_performer;
1790: exception
1791: when others then
1792: l_real_name := null;

Line 1984: FROM wf_users

1980:
1981: SELECT substr(display_name,instr(display_name,',')+ 1) || ' ' ||
1982: substr(display_name,1, instr(display_name,',') -1)
1983: INTO l_real_name
1984: FROM wf_users
1985: WHERE name = l_user_performer;
1986: exception
1987: when others then
1988: l_real_name := null;