APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on AK_RESP_SECURITY_ATTR_VALUES

Line 4246: FROM ak_resp_security_attr_values akrsav

4242: l_err_loc := 0;
4243:
4244: SELECT akrsav.number_value as realm_value
4245: BULK COLLECT INTO l_realm_values
4246: FROM ak_resp_security_attr_values akrsav
4247: WHERE akrsav.responsibility_id = p_resp_id
4248: AND akrsav.attribute_application_id = 178
4249: AND akrsav.attribute_code = p_realm_type
4250: AND akrsav.number_value IS NOT NULL

Line 4255: FROM ak_resp_security_attr_values akrsav,

4251:
4252: UNION ALL
4253:
4254: SELECT realmcomps.realm_component_value as realm_value
4255: FROM ak_resp_security_attr_values akrsav,
4256: icx_por_realms realms, icx_por_realm_components realmcomps
4257: WHERE akrsav.responsibility_id = p_resp_id
4258: AND akrsav.attribute_code = 'ICX_POR_REALM_ID'
4259: AND akrsav.attribute_application_id = 178

Line 4413: from ak_resp_security_attr_values akrsav

4409: AND (arsa.attribute_code = p_realm_type
4410: or (arsa.attribute_code = 'ICX_POR_REALM_ID'
4411: and not exists (
4412: select null
4413: from ak_resp_security_attr_values akrsav
4414: where akrsav.attribute_code = 'ICX_POR_REALM_ID'
4415: and akrsav.responsibility_id = arsa.responsibility_id
4416: and akrsav.attribute_application_id = 178))
4417: or (arsa.attribute_code = 'ICX_POR_REALM_ID'

Line 4420: from ak_resp_security_attr_values akrsav,

4416: and akrsav.attribute_application_id = 178))
4417: or (arsa.attribute_code = 'ICX_POR_REALM_ID'
4418: and exists (
4419: select null
4420: from ak_resp_security_attr_values akrsav,
4421: icx_por_realms realms
4422: where akrsav.number_value = realms.realm_id
4423: and akrsav.attribute_code = 'ICX_POR_REALM_ID'
4424: and realms.ak_attribute_code = p_realm_type

Line 4500: from ak_resp_security_attr_values akrsav

4496: AND (arsa.attribute_code = p_realm_type
4497: or (arsa.attribute_code = 'ICX_POR_REALM_ID'
4498: and not exists (
4499: select null
4500: from ak_resp_security_attr_values akrsav
4501: where akrsav.attribute_code = 'ICX_POR_REALM_ID'
4502: and akrsav.responsibility_id = arsa.responsibility_id
4503: and akrsav.attribute_application_id = 178))
4504: or (arsa.attribute_code = 'ICX_POR_REALM_ID'

Line 4507: from ak_resp_security_attr_values akrsav,

4503: and akrsav.attribute_application_id = 178))
4504: or (arsa.attribute_code = 'ICX_POR_REALM_ID'
4505: and exists (
4506: select null
4507: from ak_resp_security_attr_values akrsav,
4508: icx_por_realms realms
4509: where akrsav.number_value = realms.realm_id
4510: and akrsav.attribute_code = 'ICX_POR_REALM_ID'
4511: and realms.ak_attribute_code = p_realm_type

Line 4626: from ak_resp_security_attr_values akrsav

4622: AND (arsa.attribute_code = p_realm_type
4623: or (arsa.attribute_code = 'ICX_POR_REALM_ID'
4624: and not exists (
4625: select null
4626: from ak_resp_security_attr_values akrsav
4627: where akrsav.attribute_code = 'ICX_POR_REALM_ID'
4628: and akrsav.responsibility_id = arsa.responsibility_id
4629: and akrsav.attribute_application_id = 178))
4630: or (arsa.attribute_code = 'ICX_POR_REALM_ID'

Line 4633: from ak_resp_security_attr_values akrsav,

4629: and akrsav.attribute_application_id = 178))
4630: or (arsa.attribute_code = 'ICX_POR_REALM_ID'
4631: and exists (
4632: select null
4633: from ak_resp_security_attr_values akrsav,
4634: icx_por_realms realms
4635: where akrsav.number_value = realms.realm_id
4636: and akrsav.attribute_code = 'ICX_POR_REALM_ID'
4637: and realms.ak_attribute_code = p_realm_type

Line 4758: from ak_resp_security_attr_values akrsav

4754: AND (arsa.attribute_code = p_realm_type
4755: or (arsa.attribute_code = 'ICX_POR_REALM_ID'
4756: and not exists (
4757: select null
4758: from ak_resp_security_attr_values akrsav
4759: where akrsav.attribute_code = 'ICX_POR_REALM_ID'
4760: and akrsav.responsibility_id = arsa.responsibility_id
4761: and akrsav.attribute_application_id = 178))
4762: or (arsa.attribute_code = 'ICX_POR_REALM_ID'

Line 4765: from ak_resp_security_attr_values akrsav,

4761: and akrsav.attribute_application_id = 178))
4762: or (arsa.attribute_code = 'ICX_POR_REALM_ID'
4763: and exists (
4764: select null
4765: from ak_resp_security_attr_values akrsav,
4766: icx_por_realms realms
4767: where akrsav.number_value = realms.realm_id
4768: and akrsav.attribute_code = 'ICX_POR_REALM_ID'
4769: and realms.ak_attribute_code = p_realm_type