APPS.CSM_USER_EVENT_PKG dependencies on CSM_REQ_HEADERS_ACC

Line 560: FROM csm_req_headers_acc acc

556: WHERE hdr.resource_id = au.resource_id
557: AND au.resource_id = p_resource_id
558: AND NOT EXISTS
559: (SELECT 1
560: FROM csm_req_headers_acc acc
561: WHERE acc.requirement_header_id = hdr.requirement_header_id
562: AND acc.user_id = au.user_id
563: );
564:

Line 906: DELETE FROM csm_req_headers_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;
908: DELETE FROM csm_mtl_item_subinv_acc WHERE user_id = p_user_id;
909: DELETE FROM csm_mtl_sec_inv_acc WHERE user_id = p_user_id;
910: DELETE FROM csm_ii_relationships_acc WHERE user_id = p_user_id;