APPS.CSM_WF_PKG dependencies on CSM_PO_LOC_ASS_ALL_ACC

Line 2415: FROM csm_po_loc_ass_all_acc acc

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
2416: WHERE acc.user_id = au.user_id
2417: AND acc.location_id = pla.location_id
2418: AND acc.org_id = pla.org_id
2419: AND acc.RESOURCE_TYPE= decode(rcr.resource_type,'RS_GROUP','G','E'));

Line 2469: FROM csm_po_loc_ass_all_acc acc

2465: SELECT acc.location_id,
2466: acc.org_id,
2467: acc.resource_type,
2468: acc.user_id
2469: FROM csm_po_loc_ass_all_acc acc
2470: WHERE acc.location_id = p_locationid;
2471:
2472: BEGIN
2473: x_return_status := FND_API.G_RET_STS_SUCCESS;