DBA Data[Home] [Help]

APPS.ICX_USER_SEC_ATTR_PVT dependencies on AK_OBJECT_ATTRIBUTES

Line 374: from AK_OBJECT_ATTRIBUTES c,

370:
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

Line 386: from AK_OBJECT_ATTRIBUTES c,

382:
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

Line 398: from AK_OBJECT_ATTRIBUTES c,

394:
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