APPS.BIS_TARGET_PVT dependencies on WF_ROLE_LOV_VL

Line 37: REM | LOV IN PMF PAGES - replaced WF_ROLES with WF_ROLE_LOV_VL |

33: REM | retrieve_targets API |
34: REM | 13-JAN-05 vtulasi Bug#4102897 - Change in size of variables |
35: REM | 21-MAR-05 ankagarw Bug#4235732 - changing count(*) to count(1) |
36: REM | 10-APR-05 psomesul Bug#5140269 - PERFORMANCE ISSUE WITH TARGET OWNER |
37: REM | LOV IN PMF PAGES - replaced WF_ROLES with WF_ROLE_LOV_VL |
38: REM +=======================================================================+
39: */
40:
41: --

Line 2799: FROM WF_ROLE_LOV_VL wf_roles

2795: l_resp_name := NULL;
2796: ELSE
2797: SELECT wf_roles.DISPLAY_NAME
2798: INTO l_resp_name
2799: FROM WF_ROLE_LOV_VL wf_roles
2800: WHERE wf_roles.NAME = p_responsibility_short_name;
2801: END IF;
2802: --
2803: RETURN l_resp_name;