APPS.CSM_USER_EVENT_PKG dependencies on CSM_REQ_HEADERS_ACC

Line 561: FROM csm_req_headers_acc acc

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

Line 865: DELETE FROM csm_req_headers_acc WHERE user_id = p_user_id;

861: DELETE FROM csm_inv_loc_ass_acc WHERE user_id = p_user_id;
862: DELETE FROM csm_po_loc_ass_all_acc WHERE user_id = p_user_id;
863: DELETE FROM csm_req_lines_acc WHERE user_id = p_user_id;
864:
865: DELETE FROM csm_req_headers_acc WHERE user_id = p_user_id;
866: DELETE FROM csm_system_items_acc WHERE user_id = p_user_id;
867: DELETE FROM csm_mtl_item_subinv_acc WHERE user_id = p_user_id;
868: DELETE FROM csm_mtl_sec_inv_acc WHERE user_id = p_user_id;
869: DELETE FROM csm_ii_relationships_acc WHERE user_id = p_user_id;