DBA Data[Home] [Help]

APPS.ICX_REQ_SEARCH dependencies on AK_EXCLUDED_ITEMS

Line 64: from ak_excluded_items

60: return varchar2 is
61: ------------------------------------------------------------------------
62: cursor RespExclAttrs(resp_id number,appl_id number,attr_code varchar2) is
63: select attribute_code
64: from ak_excluded_items
65: where responsibility_id = resp_id
66: and resp_application_id = appl_id
67: and attribute_code = attr_code;
68:

Line 205: from AK_EXCLUDED_ITEMS

201: and a.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
202: and a.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
203: and a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
204: and not exists (select 'X'
205: from AK_EXCLUDED_ITEMS
206: where RESPONSIBILITY_ID = l_responsibility_id
207: and ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
208: and ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID)
209: order by a.DISPLAY_SEQUENCE;