APPS.PA_ROLE_UTILS dependencies on PA_RBS_ELEMENTS

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 848: FROM pa_rbs_elements

844: FROM pa_project_assignments ppa
845: WHERE ppa.project_role_id=p_role_id)
846: OR EXISTS
847: (SELECT 'Y'
848: FROM pa_rbs_elements
849: WHERE resource_type_id = 15
850: AND resource_source_id = p_role_id)
851: OR EXISTS
852: (SELECT 'Y'