DBA Data[Home] [Help]

APPS.WF_NOTIFICATION dependencies on WF_ROLE_LOV_VL

Line 1184: -- look into the wf_role_lov_vl based on display name

1180:
1181: -- If not internal name, check for display_name
1182: if (rname is null) then
1183: begin
1184: -- look into the wf_role_lov_vl based on display name
1185: SELECT name
1186: INTO rname
1187: FROM wf_role_lov_vl
1188: WHERE upper(display_name) = upper(avalue)

Line 1187: FROM wf_role_lov_vl

1183: begin
1184: -- look into the wf_role_lov_vl based on display name
1185: SELECT name
1186: INTO rname
1187: FROM wf_role_lov_vl
1188: WHERE upper(display_name) = upper(avalue)
1189: AND rownum = 1;
1190: exception
1191: when no_data_found then

Line 7335: FROM wf_role_lov_vl

7331: if (l_username is NULL) then
7332: begin
7333: SELECT name
7334: INTO l_username
7335: FROM wf_role_lov_vl
7336: WHERE upper(display_name) = upper(username)
7337: AND rownum = 1;
7338: exception
7339: when NO_DATA_FOUND then