DBA Data[Home] [Help]

APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on AMS_ACT_ACCESS

Line 895: l_access_type ams_act_access.arc_user_or_role_type%TYPE;

891: l_mktelig_rec ams_act_market_segments_pvt.mks_rec_type;
892: l_segments_rec ams_act_market_segments_pvt.mks_rec_type;
893: l_terr_resource_id NUMBER;
894: l_terr_resource_type jtf_terr_rsc_all.resource_type%TYPE;
895: l_access_type ams_act_access.arc_user_or_role_type%TYPE;
896:
897: CURSOR c_check_access_exists(p_fund_id NUMBER, p_resource_id NUMBER, p_resource_type VARCHAR2) IS
898: SELECT 1
899: FROM ams_act_access

Line 899: FROM ams_act_access

895: l_access_type ams_act_access.arc_user_or_role_type%TYPE;
896:
897: CURSOR c_check_access_exists(p_fund_id NUMBER, p_resource_id NUMBER, p_resource_type VARCHAR2) IS
898: SELECT 1
899: FROM ams_act_access
900: WHERE act_access_to_object_id = p_fund_id
901: AND arc_act_access_to_object = 'FUND'
902: AND user_or_role_id = p_resource_id
903: AND arc_user_or_role_type = p_resource_type