APPS.CSM_WF_PKG dependencies on JTF_RS_GROUP_MEMBERS_VL

Line 2411: (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)))

2407: AND cas.cust_account_id = rcr.customer_id
2408: AND cas.status = 'A' -- only active sites
2409: AND ((rcr.resource_type='RS_EMPLOYEE' AND au.resource_id = rcr.resource_id)
2410: OR
2411: (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)))
2412: AND au.enabled='Y'
2413: AND NOT EXISTS
2414: (SELECT 1
2415: FROM csm_po_loc_ass_all_acc acc