DBA Data[Home] [Help]

APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_POR_REALMS

Line 4256: icx_por_realms realms, icx_por_realm_components realmcomps

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
4260: AND akrsav.number_value = realms.realm_id

Line 4421: icx_por_realms realms

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
4425: and akrsav.responsibility_id = arsa.responsibility_id

Line 4508: icx_por_realms realms

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
4512: and akrsav.responsibility_id = arsa.responsibility_id

Line 4634: icx_por_realms realms

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
4638: and akrsav.responsibility_id = arsa.responsibility_id

Line 4766: icx_por_realms realms

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
4770: and akrsav.responsibility_id = arsa.responsibility_id