APPS.CSM_USER_EVENT_PKG dependencies on JTF_RS_GROUP_MEMBERS_VL

Line 504: (rcr.resource_type='RS_GROUP' AND rcr.resource_id IN (SELECT group_id FROM jtf_rs_group_members_vl WHERE category='EMPLOYEE' AND resource_id = au.resource_id)))

500: AND cas.cust_account_id = rcr.customer_id
501: AND cas.status = 'A'
502: AND ((rcr.resource_type='RS_EMPLOYEE' AND au.resource_id = rcr.resource_id)
503: OR
504: (rcr.resource_type='RS_GROUP' AND rcr.resource_id IN (SELECT group_id FROM jtf_rs_group_members_vl WHERE category='EMPLOYEE' AND resource_id = au.resource_id)))
505: AND au.resource_id = p_resource_id;
506:
507: BEGIN
508: CSM_UTIL_PKG.LOG('Entering spawn_po_loc_ass_all_ins for user_id: ' || p_user_id,