APPS.JTF_REGION_PUB dependencies on AK_EXCLUDED_ITEMS

Line 30: responsibility_id from ak_excluded_items

26: where region_code = p_region_code and
27: region_application_id = p_application_id;
28:
29: cursor excluded_resps (p_attribute_code varchar2) is select
30: responsibility_id from ak_excluded_items
31: where resp_application_id = p_application_id and
32: attribute_application_id = p_application_id and
33: attribute_code = p_attribute_code;
34: begin

Line 288: (select attribute_code from ak_excluded_items where

284: from ak_region_items_vl a
285: where region_code=t_region_code and
286: region_application_id = p_application_id and
287: attribute_code not in
288: (select attribute_code from ak_excluded_items where
289: responsibility_id=p_responsibility_id and
290: resp_application_id=p_application_id and
291: attribute_application_id= p_application_id and
292: attribute_code = a.attribute_code)