APPS.CSM_USER_EVENT_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 449: FROM csp_inv_loc_assignments

445: l_return_status VARCHAR2(2000);
446:
447: CURSOR l_csp_inv_loc_assignment_csr (p_resource_id NUMBER) IS
448: SELECT csp_inv_loc_assignment_id
449: FROM csp_inv_loc_assignments
450: WHERE resource_id = p_resource_id
451: AND resource_type = 'RS_EMPLOYEE'
452: AND SYSDATE BETWEEN nvl(effective_date_start, SYSDATE) AND nvl(effective_date_end, SYSDATE);
453:

Line 755: -- download csp_inv_loc_assignments

751:
752: -- download labor,expense and other mtl_system_items
753: csm_user_event_pkg.items_acc_processor(p_user_id=>p_user_id);
754:
755: -- download csp_inv_loc_assignments
756: csm_user_event_pkg.spawn_inv_loc_assignment_ins(p_resource_id=>l_resource_id,
757: p_user_id=>p_user_id);
758:
759: -- download po_location_assignments