DBA Data[Home] [Help]

APPS.WF_NOTIFICATION dependencies on WF_ROLE_LOV_VL

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

1219:
1220: -- If not internal name, check for display_name
1221: if (rname is null) then
1222: begin
1223: -- look into the wf_role_lov_vl based on display name
1224: SELECT name
1225: INTO rname
1226: FROM wf_role_lov_vl
1227: WHERE upper(display_name) = upper(avalue)

Line 1226: FROM wf_role_lov_vl

1222: begin
1223: -- look into the wf_role_lov_vl based on display name
1224: SELECT name
1225: INTO rname
1226: FROM wf_role_lov_vl
1227: WHERE upper(display_name) = upper(avalue)
1228: AND rownum = 1;
1229: exception
1230: when no_data_found then

Line 7514: FROM wf_role_lov_vl

7510: if (l_username is NULL) then
7511: begin
7512: SELECT name
7513: INTO l_username
7514: FROM wf_role_lov_vl
7515: WHERE upper(display_name) = upper(username)
7516: AND rownum = 1;
7517: exception
7518: when NO_DATA_FOUND then