APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on AK_RESP_SECURITY_ATTRIBUTES

Line 4405: FROM fnd_responsibility resp, ak_resp_security_attributes arsa

4401: l_err_loc := 0;
4402:
4403: SELECT distinct resp.responsibility_id
4404: BULK COLLECT INTO l_all_resp_with_realms_ids
4405: FROM fnd_responsibility resp, ak_resp_security_attributes arsa
4406: WHERE resp.application_id IN (177, 178, 201, 396, 426)
4407: AND resp.responsibility_id = arsa.responsibility_id
4408: AND arsa.attribute_application_id = 178
4409: AND (arsa.attribute_code = p_realm_type

Line 4493: FROM ak_resp_security_attributes arsa

4489: FROM FND_RESPONSIBILITY resp
4490: WHERE resp.application_id IN (177, 178, 201, 396, 426)
4491: AND NOT EXISTS
4492: (SELECT 1
4493: FROM ak_resp_security_attributes arsa
4494: WHERE arsa.responsibility_id = resp.RESPONSIBILITY_ID
4495: AND arsa.attribute_application_id = 178
4496: AND (arsa.attribute_code = p_realm_type
4497: or (arsa.attribute_code = 'ICX_POR_REALM_ID'

Line 4608: ak_resp_security_attributes arsa

4604: FROM fnd_responsibility resp,
4605: fnd_profile_option_values resp_profile,
4606: fnd_profile_option_values app_profile,
4607: icx_cat_store_org_assignments orgs,
4608: ak_resp_security_attributes arsa
4609: WHERE resp.application_id in (177, 178, 201, 396, 426)
4610: AND app_profile.profile_option_id(+) = g_ou_profile_id
4611: AND app_profile.level_id(+) = 10002
4612: AND app_profile.level_value(+) = resp.application_id

Line 4751: FROM ak_resp_security_attributes arsa

4747: g_site_ou_profile_value)) = orgs.org_id
4748: AND orgs.store_id = p_old_store_id
4749: AND NOT EXISTS
4750: (SELECT 1
4751: FROM ak_resp_security_attributes arsa
4752: WHERE arsa.responsibility_id = resp.RESPONSIBILITY_ID
4753: AND arsa.attribute_application_id = 178
4754: AND (arsa.attribute_code = p_realm_type
4755: or (arsa.attribute_code = 'ICX_POR_REALM_ID'