APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on FND_RESPONSIBILITY

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 4489: FROM FND_RESPONSIBILITY resp

4485: l_err_loc := 0;
4486:
4487: SELECT distinct resp.RESPONSIBILITY_ID
4488: BULK COLLECT INTO l_all_resp_without_realms_ids
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

Line 4604: FROM fnd_responsibility resp,

4600:
4601: -- get all the responsibilties with realms that can access this store
4602: SELECT distinct resp.responsibility_id
4603: BULK COLLECT INTO l_resp_with_realms_ids
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

Line 4734: FROM fnd_responsibility resp,

4730:
4731: -- get all the responsibilties without realms that can access this store
4732: SELECT distinct resp.responsibility_id
4733: BULK COLLECT INTO l_resp_without_realms_ids
4734: FROM fnd_responsibility resp,
4735: fnd_profile_option_values resp_profile,
4736: fnd_profile_option_values app_profile,
4737: icx_cat_store_org_assignments orgs
4738: WHERE resp.application_id in (177, 178, 201, 396, 426)