DBA Data[Home] [Help]

APPS.ICX_USER_SEC_ATTR_PVT dependencies on AK_REGIONS

Line 375: AK_REGIONS b,

371: cursor cust_sec_attr is
372: select b.REGION_APPLICATION_ID,b.REGION_CODE,
373: a.ATTRIBUTE_APPLICATION_ID,a.ATTRIBUTE_CODE
374: from AK_OBJECT_ATTRIBUTES c,
375: AK_REGIONS b,
376: AK_RESP_SECURITY_ATTRIBUTES a
377: where a.RESPONSIBILITY_ID = p_responsibility_id
378: and a.RESP_APPLICATION_ID = p_resp_application_id
379: and a.ATTRIBUTE_CODE = b.REGION_CODE

Line 387: AK_REGIONS b,

383: cursor int_sec_attr is
384: select b.REGION_APPLICATION_ID,b.REGION_CODE,
385: a.ATTRIBUTE_APPLICATION_ID,a.ATTRIBUTE_CODE
386: from AK_OBJECT_ATTRIBUTES c,
387: AK_REGIONS b,
388: AK_RESP_SECURITY_ATTRIBUTES a
389: where a.RESPONSIBILITY_ID = p_responsibility_id
390: and a.RESP_APPLICATION_ID = p_resp_application_id
391: and a.ATTRIBUTE_CODE = b.REGION_CODE

Line 399: AK_REGIONS b,

395: cursor supp_sec_attr is
396: select b.REGION_APPLICATION_ID,b.REGION_CODE,
397: a.ATTRIBUTE_APPLICATION_ID,a.ATTRIBUTE_CODE
398: from AK_OBJECT_ATTRIBUTES c,
399: AK_REGIONS b,
400: AK_RESP_SECURITY_ATTRIBUTES a
401: where a.RESPONSIBILITY_ID = p_responsibility_id
402: and a.RESP_APPLICATION_ID = p_resp_application_id
403: and a.ATTRIBUTE_CODE = b.REGION_CODE