DBA Data[Home] [Help]

APPS.CSM_PO_LOCATIONS_EVENT_PKG dependencies on JTF_RS_GROUP_MEMBERS_VL

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

137: AND cas.cust_account_id = rcr.customer_id
138: AND cas.cust_acct_site_id = p_cust_acct_site_id
139: AND ((rcr.resource_type='RS_EMPLOYEE' AND au.resource_id = rcr.resource_id)
140: OR
141: (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)))
142: AND au.enabled='Y';
143:
144: CURSOR l_location_access_csr(p_location_id IN NUMBER, p_user_id IN NUMBER)
145: IS

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

297: AND NOT EXISTS( SELECT 1 FROM csp_rs_cust_relations rcr
298: WHERE cas.cust_account_id = rcr.customer_id
299: AND ((rcr.resource_type='RS_EMPLOYEE' AND au.resource_id = rcr.resource_id)
300: OR
301: (rcr.resource_type='RS_GROUP' AND rcr.resource_id IN (SELECT group_id FROM jtf_rs_group_members_vl WHERE group_id<>p_group_id AND category='EMPLOYEE' AND resource_id = au.resource_id))))
302: AND au.resource_id=p_resource_id;
303:
304: l_error_msg VARCHAR2(4000);
305: l_return_status VARCHAR2(20);