APPS.WF_ENGINE_RAC dependencies on FND_LOOKUP_VALUES_VL

Line 74: from FND_LOOKUP_VALUES_VL

70: l_dummy number;
71: Begin
72: select count(1) into l_dummy
73: from (select null
74: from FND_LOOKUP_VALUES_VL
75: where LOOKUP_TYPE='WF_RAC_ENABLED_TYPES'
76: and ENABLED_FLAG='Y'
77: and (p_itemtype is null OR substr(LOOKUP_CODE,1, instr(LOOKUP_CODE,':',1)-1)=p_itemtype));
78: if l_dummy>0 then

Line 97: from FND_LOOKUP_VALUES_VL

93: l_string varchar2(100) := upper(p_itemtype)||':'||upper(p_processname);
94: Begin
95: select count(1) into l_dummy
96: from (select null
97: from FND_LOOKUP_VALUES_VL
98: where LOOKUP_TYPE='WF_RAC_ENABLED_TYPES'
99: and ENABLED_FLAG='Y'
100: and LOOKUP_CODE=l_string);
101: if l_dummy>0 then

Line 153: from FND_LOOKUP_VALUES_VL

149: cursor c_RACTypes is
150: select WITV.NAME
151: from WF_ITEM_TYPES_VL WITV,
152: (select unique(substr(LOOKUP_CODE,1, instr(LOOKUP_CODE,':',1)-1)) L_CODE
153: from FND_LOOKUP_VALUES_VL
154: where LOOKUP_TYPE='WF_RAC_ENABLED_TYPES'
155: and ENABLED_FLAG='Y') WFRAC
156: where WITV.NAME=WFRAC.L_CODE
157: and (itemtype is null or WITV.NAME=itemtype);