APPS.CSM_USER_EVENT_PKG dependencies on CSM_REQ_LINES_ACC

Line 611: FROM csm_req_lines_acc acc

607: AND hdr.resource_id = au.resource_id
608: AND au.resource_id = p_resource_id
609: AND NOT EXISTS
610: (SELECT 1
611: FROM csm_req_lines_acc acc
612: WHERE acc.requirement_line_id = line.requirement_line_id
613: AND acc.user_id = au.user_id
614: );
615:

Line 903: DELETE FROM csm_req_lines_acc WHERE user_id = p_user_id;

899: DELETE FROM csm_mtl_txn_lot_num_acc WHERE user_id = p_user_id;
900: DELETE FROM csm_mtl_unit_txn_acc WHERE user_id = p_user_id;
901: DELETE FROM csm_inv_loc_ass_acc WHERE user_id = p_user_id;
902: DELETE FROM csm_po_loc_ass_all_acc WHERE user_id = p_user_id;
903: DELETE FROM csm_req_lines_acc WHERE user_id = p_user_id;
904:
905: DELETE FROM csm_req_line_Details_acc WHERE user_id = p_user_id;
906: DELETE FROM csm_req_headers_acc WHERE user_id = p_user_id;
907: DELETE FROM csm_system_items_acc WHERE user_id = p_user_id;