APPS.PA_ROLE_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 833: * pa_rbs_elements and pa_resource_list_members

829:
830: /***********************************************************
831: * Bug - 3575890
832: * Desc - We should also check if the role exists in
833: * pa_rbs_elements and pa_resource_list_members
834: * table.
835: *********************************************************/
836: cursor c_role_in_use is
837: SELECT '1'

Line 853: FROM pa_resource_list_members

849: WHERE resource_type_id = 15
850: AND resource_source_id = p_role_id)
851: OR EXISTS
852: (SELECT 'Y'
853: FROM pa_resource_list_members
854: where project_role_id = p_role_id);
855: v_dummy varchar2(1);
856: Begin
857: open c_role_in_use;